=INDIRECT("Sheet2!A1")

HTH. Best wishes Harald

"cwolterman" skrev i melding
...
I have a formulas referencing cells in another worksheet. When rows are
added or deleted from the worksheet the formulas are either changed to
skip
the new row or receive an #REF! error when a row is deleted. Regardless
of
what happens in the worksheet I want the formulas to remain the same