Linking

[excelstacy]

I have a workbook with a summary page (Weekly Totals) that summarizes all hours posted for each week by project. I am trying to find a way to easily automate the summary links when I create a new sheet for the upcoming week. How can I create a link to a worksheet that has not been created yet? Can this be done?

Any feedback would be appreciated. I have attached the file I am referring to. Cell B33 on Weekly Totals has a SUMIF formula, but it is referring to that particular worksheet name. Can I have a formula that looks at all worksheets in that particular Cell A1? I know you can't do a 3D SUMIF reference. I am trying to get each set of hours (PTO, Non-Project, Pre-Project...) pulled from the correct week that corresponds to the Weekly Totals sheet (reading from the correct week date).

Thank you!
Stacy