Get data from multiple Excel files using the file path as parameter

Hi Anonymous 

What I meant was that the Master file you created will have a list of the files you want to load data from, something like this

Create a table from this data (CTRL+T) then load into Power Query/Power BI.  Add a custom column like this

which will give you the contents of each file in that new column (as tables) like so

You can then expand these tables (click on the double haeded arrow in the header) and extract the data you want.

Regards

Phil

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.