I have designed a spreadsheet with multiple worksheets that perform financial
functions. These multiple worksheets pull from one specific line (column 2)
in one of its worksheets (DATA). My idea is that "worksheets 2-5" would pull
from column 2 of DATA as its data is scrubbed and moved elsewhere or deleted.

Problem is I get a #REF! error in worksheets 2-5 anytime data in column 2 of
DATA is deleted. If the data is moved, the cell references in worksheets 2-5
reflect those changes..in other words, the data is static in worksheets that
are supposed to be dynamic.

Umm...newbie thinks he knows why it is doing this but wonders how (I) can
make it so that the multiple worksheets pull data from the values in column 2
of DATA only.

Your help is greatly appreciated!