How to Combine Multiple Excel files into one

Using Power Query to combine multiple Excel files from same folder

We can combine multiple Excel files from a folder into one Workbook and create a table or a a pivot table report based on the consolidated data.

Credit to Leila Gharani