Cell reference between worksheets

[Cassie Rodgers]

I have a spreadsheet that has multiple worksheets. The first worksheet is a
status tracking tool for the other worksheets which contain all the daily
detail. I want to be able to refernce specific cells in each worksheet and
have them populate the first worksheet with updated detail.

As I add new detail to the individual sheets, I insert a column so that the
most current detail is listed on the top. The detail I want to populate the
tracking worksheet is in cell A17 of the individual worksheets. I have tried
to reference it as an absolute value using $A$17. What happens is when I
insert a new row, it shows $A$18.

How do I get this to always reference A17? I've tried to name the cell but
that didnt work either.

 

[Sean Timmons]

=INDIRECT("$A$17") will do it

 

[Cassie Rodgers]

Does this work if the cell I need referenced is on a different worksheet?

 

[Cassie Rodgers]

Thanks much! It worked!
--
Cassie

=INDIRECT("$A$17") will do it

 

[Gord Dibben]

=INDIRECT("Sheet1!"&"$A$17")


Gord Dibben MS Excel MVP