Create a formula referencing a sheet

[lynxbci]

I have a workbook with a header sheet and 12 seperate sheets containing
data for months 1 to 12 (named jan,feb,mar etc)

I want to enter a month into a cell on the header sheet, and then all
formulas on that sheet to refer to that particular sheet and retrieve
data.

example

Header sheet has cell A1 and i have typed JUN in it

The cell B1 has =JUN!C20 and returns C20 from the june sheet

If I then type AUG in A1 how can i update the (=JUN!C20) to =AUG!C20
without retyping it for each of my 60 or so refernces.

Thanks

 

[J.E. McGimpsey]

One way:

B1: =INDIRECT("'" & A1 & "'!C20")

I have a workbook with a header sheet and 12 seperate sheets containing
data for months 1 to 12 (named jan,feb,mar etc)

I want to enter a month into a cell on the header sheet, and then all
formulas on that sheet to refer to that particular sheet and retrieve
data.

example

Header sheet has cell A1 and i have typed JUN in it

The cell B1 has =JUN!C20 and returns C20 from the june sheet

If I then type AUG in A1 how can i update the (=JUN!C20) to =AUG!C20
without retyping it for each of my 60 or so refernces.

Thanks

 

[lynxbci]

Thankyou, late i know but better than never