Gather data from all sheets in folder, convert finished workbook to CSV

Hey,

I have around 200 workbooks in numerous subfolders and i need to compile all the data in there into one spreadsheet, or a spreadsheet per folder and convert that to a CSV.

Theres around 30 subfolders and folders within that, but if its not possible or a pain, for it to go through each one, i dont mind running it in each folder.

Im not sure if an easier function is to have the macro go into each file and save a copy as a csv, but this isnt really my area of expertise so any help would be much appreciated.

Thanks

Marcosis

Is the data the same structure in each file? please share a sample file as per the yellow banner above.