Frustrated here.

I have a workbook containing 3 worksheets.

Sheet1 lets a user enter all leads received.
Sheet2 has links to Sheet1 and provides a running total (based on dates) of
projected closed sales for each month of the year and is based on the info
entered into Sheet1.
Sheet3 is a 'Cancelled' worksheet where the user "moves" all leads entered
on Sheet1 that fall through or are "Cancelled" (cut & paste).

My problem is that when I cut and paste from Sheet1 to Sheet3, the linked
formula in Sheet2 updates itself to use the Sheet3 data instead of the Sheet1
data. (the row that is now blank on Sheet1 doesn't erase Sheet2's data.
Basically I need Sheet2's reference to remain intact so that lead that is no
longer on Sheet1 is 'erased' from Sheet2's projected sales.

Does that make sense? Thanks. This is driving me crazy.