Hi Stacy,

It sounds like you have straight cell references like "=Sheet1!A1".
Have you had a look at the VLOOKUP function in Help? That would be the
place to start, as it also sounds like it can handle what you need to
do, so that your references don't get messed up.

I hope this is helpful,

Gary