Hi Kevin,
Your goal is to produce a string that looks like
sheet53!$C$2
and to place that formula adjusted to it's new location
as the argument of INDIRECT.

cell A61: 53
test G61: ="'sheet" & OFFSET(G61,0,1-COLUMN()) & "'!$C$2"
cell H61: =INDIRECT("'sheet" & OFFSET(H61,0,1-COLUMN()) & "'!$C$2" )

The G61 and H61 internal are the address of the cell itself

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"David McRitchie" wrote in message ...
Hi Kevin,

=ROW() will provide the cell's row number
=COLUMN() will provide the cell's column number

"KevinB" wrote ...
Cool, that worked! Thx!

Now, my next issue. The formula you provided;

=INDIRECT("Sheet"&$A$61&"!$C$2")