I have several application workbooks that use a 2 sheet approach.

Sheet 1 is designed for end user input. It is pre-formatted and allows the
end-user to input only the pertinent data

Sheet 2 is very structured with very specific formulas. Its purpose is to
recalculate and rearrange the data for a specific inport into another program.

Everything works great until the end user uses cut and paste to move data
that was incorrectly entered on Sheet 1 which creates #REF! errors on Sheet 2
whereever the data was moved.

I have used both absolute and realative referenced formulas with the same
result.

Any suggestions?