Indirect reference to another sheet that can be dragged

[Brian]

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

 

[Harlan Grove]

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)