Based on date, pull sum from a range of cells?

Hello-
I have a 2 page workbook. page1 I need to input sums, based on any date I may input, collected from page 2. Page 2 I have a 12 month rolling projected forcast. On page 1 I need to input any date and have it pull (from page 2) the sum of 8 weeks out projected forcast, and sum of the last 4 weeks actual production. I have attached a sample of my workbook. Let me know if you don't understand what I need help with. I have been stuck on this for days! uhggg ;0(

Hi I'm not too sure that I have understood exactly what you want but I've tried! see the attachment
Howard

Wow! that is awesome. Thank you soooo much! The only thing it does not do is populate the info based on the WorkWeek date put into C1 on the Summary page. For instance "if I were to put ww25 (or the date = 6/16/08 whichever is easier for the function) into C1, the summary page would pull ww25 - ww32. If I were to put ww17 into C1, it would pull ww17 - ww24. Let me know if I am not correctly explaining. I can't tell you how this has helped me. You ROCK!!!

Hi, Again if I have understood you correctly, put the week number into C1 on the summary sheet and then hopefully in columns F and G the values that you want will be shown see the attached file.
regards Howard

Thank you very much for all your help!