locking excel formulas
===

I have several sheets of data that have formulas written to compare values between the sheets. These sheets are comparing current data from today to the previous data from the day before. Daily I have to move the data from the "current" sheet into the "previous" sheet and then update the "current" sheet with todays today. When I cut the data out of the "current" sheet in paste it into the "previous" sheet it will change the formulas by autmatically updating the sheet name within them, which I don't want it to do. I want the formulas to stay locked and not change when data is moved around.

The work around for this is to copy the data over instead of cutting it, but I want to see if there is any other solution for this.