Display cell contents in a second worksheet file
 

There has to be some simple way to do this that I'm missing.

I have been asked to create a worksheet (file 1) that displays selected
table row information (row-by-row) from a second file (file 2). (The column
data in file 2 is consistently located in each row, and information is a mix
of text and numbers.) The row information in file 2 is extensive and
management wants a worksheet in file 1 that displays only selected
information.

I have achieved this in file 1 using "=" to display cell information from
each cell needed in file 2, and autoupdate works great. But, when a row in
file 2 is deleted, the corresponding row in file 1 gets filled with '#REF'.
I just want to display the information in each row from file 2 without
worrying about '#REF' showing up in file 1 when a row is deleted.

Is this possible? Or, am I stuck with getting '#REF' from deleted rows.
Unfortunately, rows must be deleted from file 2 and I have to work with
separate files.

Thanks.

Jeff