=INDIRECT("Sheet1!A3")

will always point to A3

--
Regards,

Peo Sjoblom


"JM" wrote in message
...
I am trying to do a summary page to show specific fields on different
worksheets within my excel file. I understand how to show the field but
my
problem is when I insert a new row on the worksheets where the info is
referenced from it pushes the field down one row and my summary page
reference shows the new location of the original reference.. confusing I
know. I am hoping someone can tell me how to make the formula always
reference the same cell no matter how many rows/columns I insert.

Thank you for any help.