Summary workbook from multiple workbooks in same folder

[chullan88]

Dears,

I am trying to generate a workbook showing summary of progress over weeks.
The individual workbooks ( excluding summary) will be named as per the date on weekly basis. For Eg 12-5-19
19-5-19
26-5-19 etc.
All individual workbooks will have a table showing progress of items in the following format:

Structure : 50%

Finishes : 20%

MEP : 15%



In the summary workbook, there will be a table in the following format:

12-5-19 19-5-19 26-5-19 2-6-19 ... & so on
Structure : 50% 50% 50% 50%

Finishes : 20% 20% 20% 20%

MEP : 15% 15% 15% 15%


What I'm trying to achieve

In the summary workbook, I will be populating the date row manually upto the last date I require.

For the 1st week ( 12-5-19), I will update the individual file and place it in the same folder.

For the next week, I will copy 12-5-19 , rename it to 19-5-19 , update progress and place it in same folder.

After that , I need these values from 19-5-19 workbook to automatically appear in summary workbook under column "19-5-19"

And so on for all other weeks..

I cannot use VBA and would require a formula solution.



Thanks in advance..

[JeteMc]

Perhaps this tutorial video will be of some help in generating a summary workbook from multiple workbooks using Power Query. The portion of the video that deals with importing files begins at the 21:55 mark, after the commercial has played.
Edit: Here is another link to a tutorial that addresses the subject of Combining Data from Multiple Workbooks in Excel (using Power Query)
Best of luck.