I use the following formula to copy data between two worksheets

=IF('Roster'!A1='''," ",'Roster'!A1)
if A1 is null, return space, other wise copy data from A1

the problem is lots of copy pasting goes on, on the roster im copying from. this is not a problem until someone cuts and pastes. Which deletes cell A1 and makes a new one. Which messes up the formula by removing "A1" and changing it to "NAMEREF"

I took cut out of the menu bar and tool bar as a temp measure, however CTRL X is still active. Any idea how I can make this formula friendlier to cut?
mdpx