Copy Data from Multiple Workbooks into Master Workbook Daily

[gilbare]

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

[JBeaucaire]

'WORKBOOKS TO 1 SHEET STACKED
Here's a macro for collecting data from all files in a specific folder.

Workbooks to 1 Sheet

The parts of the code that need to be edited are colored to draw your attention.