Sounds like the original cells are being deleted - maybe by the import
or maybe by a Cut and Paste operation.

You can make the formula survive this by changing it to
=INDIRECT("Sheet1!G4")

This formula will not adjust if you copy or move it.
The following will:
=INDIRECT("Sheet1!"&ADDRESS(ROW(),COLUMN(),,1))
Placed in Sheet2!G4 it will reference Sheet1!G4.
copied to Sheet2!H5 it will reference Sheet1!H5

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup