Hi,
I have 5 years experience in Excel VBA programming and I write scripts on MAC os too which is slightly different than scripts in Windows, and quite different when it comes to file handling.
I can write you a script that loops through all the files in every subfolder (I might need to know the number of possible levels) of a selected folder, opens the Excel files and collects the relevant data into a new file.
Regards,
Balint