How to find and correct errors on copied sheets

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.

Try this.

Find: [Budgetv15 (version 1).xlsb]

Replace:

That is, an empty replace field.