Excel 2003 Data Linking from another Excel file question

Hi everyone,

I have 2 excel files, the source (data file), and the destination (printable label).

On the destination file, in a cell I have placed in the formula:

='[Source File.xls]Worksheet'!$F2

The data shows up perfectly on screen. However, as soon as I delete the Row 2 in the source, the destination becomes:

='[Source File.xls]Worksheet'!#REF!

The reason I deleted Row 2 in the source is so that I can move the data in source up one row and let the next row be my next set of data for the destination.

Is there a way to keep the formula to always reference the source cells?

Thanks

Michael