Change Tab referenced by number in a cell

[magpie2000k]

Hi folks,

I have a few spread sheets where a summary page exists and references one of the other tabs depending on the day of the month.

So I have 23 tabs named Day 1 Day 2 Day 3 etc

On the summary page I have formulas like

=SUM('Day1'!C12+'Day1'!C24+'Day1'!C36)

My question is is it possible to have a cell on the summary page that I can just change from 1 to 2 to 3 etc and I can then write the formula to look at Day 1 day 2 etc dpending on what is in that cell.

Hope that makes sense

I ask because at present the staff need to select the cells and do ctrl F and replace "day 1" with "Day 2" which about 10 times a month they get wrong and I need to correct the formulas.

Cheers

 

[Legacy 143009]

Use INDIRECT function.

=SUM(INDIRECT("'Day"&A1&"'!C12")+INDIRECT("'Day"&A1&"'!C24")+INDIRECT("'Day"&A1&"'!C36"))

A1 is the cell where you'll have 1, 2, 3...

 

[magpie2000k]

Your a star that will make my life sooooo much easier....

 

[Legacy 143009]

Your a star that will make my life sooooo much easier....

Have a nice day ?