Retaining cell reference

Hi
I want to display the text from cells in sheet 'Occupation data' in another sheet

I am using this formula =+'Occupation data'!A2 which works OK

However, when I delete row 2 in the 'Occupation data' sheet, the new data in Occupation data'!A2 is not displayed and the formula shows =+'Occupation data'!#REF!

Is there a method/formula that will retain the reference to Occupation data'!A2 after rows are deleted or added
Cheers

One simple thing which you

One simple thing which you can do is copying the cell contents and then paste values.