The formula in sheet2 looks like this:

=IF(sheet1!A1="","",sheet1A1)

Here's the problem: If I delete the first row in Sheet1, the formula in Sheet2 will have an error: =IF(sheet1!#REF!="","",sheet1#REF!)

How to correct this so that if I delete the row(s) in Sheet1, the references in Sheet2 will still point to the corresponding data in Sheet1?