I have used sheet names as part of my formula, however, I have other
sheets with the same design.  I have made a copy of the sheet, but it
carries the original sheet name.  Is there a way of using the find and
replace feature to change the sheet name in the formula e.g. sheet1!a10
to sheet2!a10

I have a large number of cells that require the sheet name to be
changed, hence my question.  I hope someone has an answer.

Thanks