Lookup data from multiple sheets, based a on date

I have 13 sheets in a workbook, 1 for each month, and 1 summary page that will only work properly on mondays(and that's the way I want it). On the summary page there are dates that will change and certain type of information under each date that correspond to titles of information on the other sheets. I want the summary page to autopopulate with the number found in the appropriate row, from the apropriate sheet. It's a little awkward to explain, but i have attached the spreadsheet i'm working with. On "WEEKLY" sheet, i want the cells with borders to be automatically be filled in with the numbers found on the different sheet by the appropriate date. If you need mroe info, please let me know. Thank you.

Thanks very much, That's perfect! I am fairly new to excel and everything I know is just from goofing around and trying new things. Do you think you could tell me briefly (you don't have to go into too much detail if you don't want) how you did that?