Here's my predicament...

My workbook is set up to track a team member's progress throughout the month. Throughout the day, the team member updates the spreadsheet with their progress.
Cell B60 captures their progress in integers (1, 2, 3, 50, 120, etc.). What I am looking for is to have cell B1 capture the value of cell B60 at a certain time each week.
The date that the information needs captured is found in cell L52. I would prefer to have the information captured at 9:00 PM on the night of the date in cell L52.

For example:
If today is 05/13/13 and...

B60 = 84
L52 = 05/13/13

I want to come in to work on 05/14/13 and see what cell B60's value was at 9:00 PM on 05/13/13. I want this populated in cell B2.

I will be adding a new worksheet each month for the current month so I need the macros to work on the entire workbook and not just a single worksheet.

The spreadsheet will likely be closed at 9:00 PM at night, does that make a difference? Will the macros just run the next time the workbook is opened? If this cannot be done to run this macros at a specific time, I could also achieve my solution by capturing the last value entered on the date found in cell L52. (I chose 9:00 PM because it was a time well after the team member is off work).
I have Excel 2007 if that makes a difference.
Any help would be appreciated. It's been many years since I took computer programing in college and I have forgotten most of my programming skills. Thanks!