Do you want sheet 2 to be a backup of sheet 1? No, let me say that better: Do you want it so that if make a mistake on sheet 1, you can copy sheet 2 back and start over from the last save point? Or are you looking for sheet 2 always and immediately to reflect changes in sheet 1?

If you want all values on sheet 1 to show up on sheet 2, then maybe the easiest way is just to have every cell on sheet 2 point to the corresponding cell on sheet 1.

If you want a backup arrangement, then it should be just a matter of copying all the formulae from sheet 1 to sheet 2 periodically—do a mass cut-and-paste, in other words.

I know this isn't a complete explanation, but I wanted to find out more about your goal first.