Say the summary sheet has the months entered in A1 to A12, spelled *exactly*
the same as the sheet tabs.

In B1, enter this formula:

=INDIRECT(A1&"!A1")

And copy down 12 rows.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"ATK" wrote in message
...

I posted this before, but for some reason, it never showed up.

I want to be able to take a list of months in a spreadsheet and add
these months to an equation without having to type it out every time.
Let me explain:

I have a column of text ranging from January to Dec. I also have
worksheets titled from Jan to Dec. I need to reference various cells
in each of the spreadsheets in a summary spreadsheet, but each
reference cell is the same for each month, i.e. always January!$A$1,
February!$A$!, etc.

Is there a way I can write an equation that will allow be to copy the
months in the summary sheet and append the $A!1 into the text and get
it to return the value of the respective cells?


--
ATK
------------------------------------------------------------------------
ATK's Profile:
http://www.excelforum.com/member.php...o&userid=27662
View this thread: http://www.excelforum.com/showthread...hreadid=472728