VBA for consolidating data from excel sheets in subfolders

[mulkishi]

I have Folder name 2019, inside that I have subfolders in the name of months like "01-2019, 02-2019" so on.... in that I have further subfolders named as date like 01-01 for 1st jan, 02-01 for 2nd jan, 03-01…. and so on and inside each folder there is a excel sheet with name 'Excel Report'

These are all system generated data

I need to merge all the data from that excel in one workbook to make a report out of it. How can it be done?

All the excel sheet has same headers.


Can anyone give me a VBA code for the same please.

 

[alansidman]

You should be able to quickly combine these files using Power Query.

https://www.google.com/search?q=pow...69i57j69i60.5139j0j4&sourceid=chrome&ie=UTF-8