Probably late to the party on this one, if it's just formulas in cells you need to change rather than VBA code can you not write new VBA code to overwrite the incorrect cells with the new formula?
Open each Excel sheet, run the VBA code and your sheet will be up to date. Rinse and repeat for...