Search and Replace Part of Formulas

Hi All -

I am working on a Financial Model and have the following problem:

There is a 'Reporting' tab in the model that collects data from different other tabs. - In particular, there is a series of formulas that receives inputs from a tab called "LoB".

Example A:

=IF('LoB'!K20="";J180;'LoB'!K20)

Example B:

='LoB'!K4

I have now added two sceanario-tabs (versions) of the 'LoB' to the model. These tabs are labelled 'Lob1' and 'Lob2'.

Question: How can I replace in all 2'500 formulas above the 'LoB'!-reference with an IF formula that allows the selection of the scenarios.

e.g. how can I change the formula above (Example B) into:

=IF(scenario=1;'LoB1'!K4;'LoB2'!K4)

Main issue: the solution would have to work for Example A (above) as well.

I have tried to solve the problem with a macro that is able to replace all of the 2'500 formulas, but haven't found a solution yet.

Any help would be very much appreciated! - Thank you.

Rgds,
Alain