Importing Multiple Files at the Same Time into Multiple Queries

Hi,

I have a folder full of about 30 different files and I would like to make them all part of the same dataset. Is there a way to pull them all in at once, so I have 30 different queries? It seems like the only way is to do them as all one table in one query. I don't want to have to go Get Data and select each file individually, considering they all only contain 1 table. If they were all csv files I could make them 1 workbook, but about half of them are pdf.

Thanks