How to find and correct errors on copied sheets

[Osprey2]

I have copied a sheet from one workbook to another, The sheet contains many formulas. These have been transferred Properly to the new sheet,but as well as the formula the copying has Included the name of the donor workbook.
A typical formula is like this. "='[Budgetv15 (version 1).xlsb]OHTapes'!G11". Although this works it is not satisfactory.
I have tried Using CtrlF to find and change by using The line from = to ] as the search string and"" as the replacement with the hope that I could then use ' as the next search string to get rid of that aspect of the formulae.
Unfortunately my hopes were dashed when using the first search string led to an error message "There's a problem with this formula"
Can anyone suggest a way round this? It seems to me that there may be two ways. The first is a way of copying the sheets that just copies the formulas as they are. and the second is a search that doesn't have to have a perfect formula.
Any help would be welcome though
John
ps This is not trivial for me. There are 6 sheets to be copied and each contains 50 or so formulas.

[AliGW]

Try this.

Find: [Budgetv15 (version 1).xlsb]

Replace:

That is, an empty replace field.

[Osprey2]

Ali,
thanks for that which I will try right away. What about the separators which occur first in the line and just after the sheet name? Can I use ' and nothing?
John

[Osprey2]

Ali
Many thanks for your help which was brilliantly successful. It even got rid of those pesky grey commas at the same time, and I was thinking I would have to deal with them separately.
John