We need to develop a VBA macro to extract data from multiple Excel files.
Those files are saved in different sub-folders. All those files have the exact same format. See attachment to have the folder/sub-folder/files structure.
Data should be extracted from every single file and every single sub-folder and be consolidated in a master sheet. See attachment as well.
The macro should be as light as possible since data will need to be extracted from thousands of files.