Hi,

I need some help with something I am trying to do with a spreadsheet. I have a workbook with 41 sheets in it and I need to change a formula that is in 20 of the worksheets (they all have the same format) which can be reference by codename - this is from another code I have running on the same workbook:
Select Case (Sh.CodeName)
    Case "Sheet18", "Sheet19", "Sheet20", "Sheet21", "Sheet22", "Sheet23", "Sheet24", "Sheet25", "Sheet25", "Sheet26", "Sheet27", "Sheet28", "Sheet29", "Sheet30", "Sheet31", "Sheet32", "Sheet33", "Sheet34", "Sheet35", "Sheet36", "Sheet37"
.
There are specific cells that the formula is in which are "B6:N12", "B15:N21", "B24:N30", "B33:N39", "E44:K44"

The Code that is in B6 for example is:
=IF('Data Extract 2'!$C4="",'Data Extract 2'!$B4,'Data Extract 2'!$C4)
I want to change all the cells to be 
='Data Extract 2'!$B4
where the B4 changes depending on cell. I can't do a Replace All because of the "B4/C4" being different in each cell.

I have attached a sample of the format I'm working with:
rotatest10.xlsx