Updating Sheet References

[lostboyca]

Each week I have to create a sheet with the week for example I start with the following for the workbook

existing sheet name: week 1, week 2

In week two I have cells with a bunch of formula calculating from week 1 such as =E6+'week1'!E13, =F6+'week1'!F13

New week begins I have to create another sheet name week 3. so my calculation for this cells need to be =E6+'week2'!E13, =F6+'week2'!F13

I have about 30 cells that needs to have these calculations. On week 3, I was thinking to have a cell where I input the sheet name and then when I input the sheet name on cell for example week 2. It will automatically change anything that says week 1 in the calculation automatically which means my calculation will be for week 2.

Hope that clears what I'm trying to do.

Again thanks for the Help,

Lostboyca