Getting Multiple queries from a folder

[learningpython]

Hello Experts.

System: Excel 2016
I have a folder with about 50 .xls spreadsheets, they are not the same formats and I do not want to combine
=Excel.Workbook([Content]), I tried but in vain. Please can you share the link to help me resolve this Issue please.

 

[Matt Allington]

So, what’s the problem If you don’t want to combine?

 

[learningpython]

So, what’s the problem If you don’t want to combine?

Hi @Matt thank you. I want as a initial step, to have each of the sheets loaded into separate queries and use Join with Full Inner join to extract a report, see the final pic ( I am not sure how to achieve the final pic, yet) but when I point to the folder and bring all the data is combined. But please advice me, if I can achieve the final result just by pulling the all the relevant files in a combined files as I get now using Excel.Workbook([contents]). Await for your advice.