Need to have multiple worksheets use a single worksheet

I need to have multiple worksheets use a single worksheet to do
calculations.the calculation worksheets needs to get info from the indivdual
worksheets. can you use varables in the formulas. ex ='WEEK 1'!B3 can you use
a varible for 'WEEK 1'!

Check in the help file for info on the INDIRECT() function

If you put "Week 1" in cell A1, your formula would read

=INDIRECT("'"&a1&"'!B3")

PS - If you change your tab/sheet names so that there are no spaces - Week1
or Week_1, as examples - you can dispense with the single quotes around the
sheet name

"storm5527" wrote:

> I need to have multiple worksheets use a single worksheet to do
> calculations.the calculation worksheets needs to get info from the indivdual
> worksheets. can you use varables in the formulas. ex ='WEEK 1'!B3 can you use
> a varible for 'WEEK 1'!