Macro for extracting amount with dates from various workbooks (Excel 2016)

I need code for the following condition

I have a folder like "xyz", in "xyz" there are thirty or thirty one workbooks (subject to the month), now if I want to take the figures from all these workbooks of a specific person like "nawaz" with different dates, then I need code for this condition.
NOTE:
Please keep in mind, First, in all the above workbooks it is not necessary the name will be exist, but in some of them.
Secondly in addition to the above workbooks there will be one more workbook in the same folder in which all the extracted amount with the date will required, this workbook must be opened with the code.Thirdly, the data in the color range may be more or less in different dates.

Look at the sheets

How do i import all these 5 files into the excel thru power query
for more see the picture

Try

Please Login or Register  to view this content.

Firts When i run this macro, it asks the path, i provide the path but at the path there is no file, whereas there are five files aready there, Secondly there is another macro enabled file in which your code are already exist i.e "example" in which I want to import all these files, please see the picture

Are you talking to me?
I always test my code before I post when I can test for myself.

Sorry sir, there were some misunderstanding, I did it, thanks Mr Jindon

is there any possibility shown by Mr ImranBhatti above