Thanks to all that worked great, I figured it out while waiting for a
response, Thanks

"Pete" wrote:

You can use Edit | Replace (or CTRL-H). Highlight the cells you want
this to happen to, then CTRL-H, and in the find box enter:
worksheet_name!
and in the replace with box enter:
other_worksheet_name!
then click the Replace All button.

This assumes that you want to link to the same cells on the two
worksheets, just the worksheet name needs to change.

Pete