I am using two worksheets (in the same file), each containing a vertical list
of names. Worksheet B pulls a list of these names from from Worksheet A
using "=worksheetA!cell# At times I must delete a row containing a name from
Worksheet A. I thought this would delete the data in Worksheet B and move
up all the new data in Worksheet A into Worksheet B since I deleted a row and
all the names below this row moved up to a new cell location. I have also
used the "$" function in my formula, but no luck...........as everytime I
delete a row in Worksheet A, the copied cell from A that is in B changes to
#REF. It seems that Worksheet B is not recognizing that all the data in A
has moved up one row (via the deleted row).

Any suggestions ?