Mass formula change

Hi all,

I need to change several formulas in several protected sheets.

There are the formulas that need to be changed. They are located at Algoma-Working!B25 to Algoma-Working!B30:

=COUNTIFS(Algoma!F3:F299, ">="&TODAY()-7)

=COUNTIFS(Algoma!K3:K2999, ">="&TODAY()-7)

=SUMIF(Algoma!K3:K2999,">="&TODAY()-7,Algoma!I3:I2999)

=SUMIF(Algoma!L3:L2999,">="&TODAY()-7,Algoma!I3:I2999)

=SUMIF(Algoma!N3:N2999,">="&TODAY()-7,Algoma!I3:I2999)

They need to be changed to:

=COUNTIFS(Algoma!F3:F299, ">="&TODAY()-8, Algoma!F3:F299, "<"&TODAY()-2)

=COUNTIFS(Algoma!K3:K2999, ">="&TODAY()-8, Algoma!K3:K2999, "<"&TODAY()-2)

=SUMIFS(Algoma!I3:I2999, Algoma!K3:K2999, ">="&TODAY()-8, Algoma!K3:K2999, "<"&TODAY()-2)

=SUMIFS(Algoma!I3:I2999, Algoma!L3:L2999, ">="&TODAY()-8, Algoma!L3:L2999, "<"&TODAY()-2)

=SUMIFS(Algoma!I3:I2999, Algoma!N3:N2999, ">="&TODAY()-8, Algoma!N3:N2999, "<"&TODAY()-2)

Where it gets complicated is there are 60 other sheets that have the same formula and also need to be changed, but the formula is slightly different in each sheet. They are the same except for "Algoma," which is "Amherst" in the next sheet, for example.

To complicate matters further, the sheets are protected with the password rudolph.

Is there a macro that can make this change for me?