Here's the story and I'm hoping someone here can help. I have a workbook
with four sheets in it. I have the functions setup to import the information
of the same line from the preceeding sheet. Each line has calculations to it
that also rolls itself (by function) to the next sheet.

The problem we are having is this: If a line item is deleted from sheet 1,
on sheet 2 it shows itself with the REF# error and the sum totals at the
bottom of that sheet recieve the same error.

Is there an additional function that I could add that if a line is deleted
on sheet 1 it would delete out the others and not cause an error in the total
sheet calculation at the bottom of sheet 2?