I have a workbook that in Sheet3 has a cell with the following formula
=IF(ISBLANK(Sheet1!$A$16),"-",Sheet1!$A$16)

Anyway if I delete row 16 on Sheet 1 and everything else shifts up then this
formula becomes

=IF(ISBLANK(Sheet1!#REF!),"-",Sheet1!#REF!)

Is there anyway to prevent this and make it just pull the data that is now
in Sheet1 A16