Power Query Novice!

Hello all (I hope I am posting this in the correct forum)

1. I am endeavoring to create a power query to aggregate all data from workbooks in a folder(subfolders).
2. Folder (subfolder) contains multiple extensions (IE .jpg,.pdf etc.) I have filtered those.
3. I want to aggregate data from single worksheet (each workbook contains 6 worksheets)
4. All columns in worksheet are named identical.
5. I want to compile the entries below into a single worksheet
6. I cannot for the life of me determine how to map for single worksheet.
7. EX: ABC Invoice .xlsx want data from only worksheet titled ledger
8. ANY HELP WOULD BE GREATLY APPRECIATED (sorry for yelling)

AawwYeahh

Which version of Excel are you using? Some earlier versions of PowerQuery are not so good on the import side, so we need to know this.

EDIT: Your profile says 2916, so when you set up the import, PQ should give you the option to select individual tabs from your sample workbook - if all workbooks have the same structure, it will import the same things from each.

I am using Excel 2016

I know - see the second half of my post.