Indirect reference to another sheet that can be dragged
 

Can someone please help me. I have a a few sheets in a file (named by month
october, september, august...". What I am looking to do is have a cell take a
number from another sheet for an indirect reference, so once I create a copy
of a new sheet I could just replace the month and everything would be
updated. I saw one member posted an example saying =INDIRECT("" & $A$1
&"!K11"). But I was not able to drag this down the column. I am looking for
Sept! K11 would equal Oct! K11 , and Sept! K12 would equal Oct! K12 and so
on. =INDIRECT("" & $A$1 &"!)K11") keeps giving me the same cell. Also, is
it possible to use an indirect reference like this built into an if/then
statement, such as if the previously mentioned is greater than 30, then get
the number from B10.... if not, then take the number from C10....

Thanks

Indirect reference to another sheet that can be dragged
 

Brian wrote...
....
. . . I saw one member posted an example saying =INDIRECT("" & $A$1
&"!K11"). But I was not able to drag this down the column. I am looking for
Sept! K11 would equal Oct! K11 , and Sept! K12 would equal Oct! K12 and so
on. . . .

No matter what the cell, if you want cell ZZ## in the active worksheet
to equal the value in cell ZZ## in the worksheet nemed in cell A1 in
the active worksheet, try

=INDIRECT("'"&$A$1&"'!RC",0)