Power Query Novice!

[AawwYeahh]

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

 

[AliGW]

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.

 

[AawwYeahh]

I am using Excel 2016

 

[AliGW]

I know - see the second half of my post.