I've attached a spreadsheet which I will be using as a master to collate data. I will be receiving various copies of the same spreadsheet, and be keeping them in individual folders named by day - so in folder 11062012, there will be multiple versions of the attached, but with data in. Is there a way to collate all of the spreadsheets in the folder into a spreadsheet for the day, then at the end of the week use the same code to collate those spreadsheets into another master spreadsheet.

Had a look around but can't quite find what I need, hope you can help!

Master data capture.xlsx