Link Value Update during COPY
 

I have created a Master worksheet that has links to another master worksheet.
Serveral hundred cells with the link. When I need to create a useable copy,
I copy both worksheets from the Master. I need to FIND AND REPLACE all the
names in order to replace the actual worksheet names for the proper links.
Unfortunately it requires me to respond after each cell change to UPDATE the
new Source (Link). This is really time consuming. It is, by the way, the
same worksheet link thoughout the copied worksheet. Is there a way I only
have to respond once for the entire FIND AND REPLACE routine instead of
during each cell change?