replace sheets and then the formulas automatically update instead of Ref error

Hi Everybody!

The problem i am having is that i have a workbook with formula's linked to a variety of worksheets. What i want to do is replace some of the sheets and then the formulas automatically update.

However, when i add the new sheets (even after re-naming the sheets the same as the old ones i want to replace) all i get is #ref!

Is there a way round this as i have a lot of prepared work sheets that i want to "slot" into the original work book

thanks in advance

You may try this way:
Inserting a new sheet in your work book, and then copy the old sheet to the new one. Using REPLACE comand changes the old sheet's name to the new sheet's name in the spread sheet which contents the functions. At last,delete the old sheet.
My english is not good enough.Wishing you can understand what i said.