I have multiple formulas mostly vlookup based on sheet B, that use information from sheet A to generate a report.

I need to be able to update the information on sheet A without breaking the formulas on sheet B.
Every time I cut (and sometimes it seems at other random times, but I think it is the same issue) any data, it breaks any formulas I have on sheet B that refference that cell and I get a #REF! error. I even tried change the formulas to use all absolute $ $ cell references, but it did not fix it.

Is there a way to prevent this? I can't lock/protect sheet a because it needs to be edited daily base off of information the report on sheet B is generating. I also have about 1200 cells with different formulas on sheet B, each one has different cell refferences (a combination of lots of typing and dragging the formulas).

Thanks!