array formula with sheetnames

[kendel]

Hello, This is probably pretty easy for many readers.
I have a master metrics workbook with days, weeks, month:
sheet 1 = month
sheet 2 = week 1, (sheet 10 = week 2, ...)
sheets 3-9 = weekdays; 1, 2, 3, ...
data is entered into the weekdays sheets and summerized with array formulas in the week and month sheets
month cell B2 = SUM(week1!B2+week2!B2+week3!B2+week4!B2)

week cell B2 = SUM('1:7'!B2)

I would like to replace the sheet references in the weekly formula
so when the sheets are renamed with dates for the actual workbooks the formula would reflect the change in the sheetnames
example: = SUM('3-8:3-14'!B2)

thank you
Kendel (win7,excel2010)

 

[kendel]

Hello, this is solved.
My workbook formulas were scrambled somehow so when I copied the master with new dates for sheetnames I got bad stuff, so thought my understanding was faulty. GIGO
alls good.