ExampleSheet.xls

Heeelllpp! please!

I'm new to macros and I've barely managed to piece together this spreadsheet as it is. What the attached sheet does is allow the staff at my hotel to track "arrival experience" of our guests at the hotel. I've set a standard for how many guest check-ins daily/weekly need to be informed of ammenities at our hotel. I've pretty much nailed the daily tracking portion to my satisfaction and that's whats contained in the attached spreadsheet. What I need now is a macro designed to compile the data from these daily spreadsheets and add them to a weekly tracking spreadsheet. All I need is the data from cell F31 to carry over to a new sheet in this format:
Week 1 - 08/12/12 - 08/18/12
08/12 - "(data from cell F31 in the sheet in the same folder titled 08-12-2012.xls)"
08/13 - "(data from cell F31 in the sheet in the same folder titled 08-13-2012.xls)"
08/14 - "(data from cell F31 in the sheet in the same folder titled 08-14-2012.xls)"
08/15 - "(data from cell F31 in the sheet in the same folder titled 08-15-2012.xls)"
08/16 - "(data from cell F31 in the sheet in the same folder titled 08-16-2012.xls)"
08/17 - "(data from cell F31 in the sheet in the same folder titled 08-17-2012.xls)"
08/18 - "(data from cell F31 in the sheet in the same folder titled 08-18-2012.xls)"
Week 2 - 08/19/12 - 08/25/12 etc.....

The Master sheet is titled "Arrival Experience Master.xls" and is located at S:\front desk, they open this daily, fill it out and once they click end of day the file is saved as "mm-dd-yyyy" in a new folder at S:\front desk\arrival experience and this is where I would like the new weekly file to be located.

Sorry for the lengthy description, I just know it's helpful to add as much information in regards to my intent. Please let me know how much of this is possible and if so what the macro may look like...