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.
--
Cassie