Find and replace one array with another

I use a tracker for my students progress. It has 12 pages representing 12 weeks in a term. It has several formulas from cells AO4 to Ak30 that I filled dragging one of the formulas throughout. Some of the values in the formulas are absolute references some are not. This whole array of formulas got corrupted on accident by using find and replace. The problem is this workbook has been multiplied over 100 times for many students in one school. Each workbook needs to be updated on all 12 pages. I started correcting the corrupted files one worksheet at a time using the same method of dragging I used to create them in the first place, but it was taking 3-4 minutes per file. Is there a faster way of doing this?

Sounds good. I don't have access to my school files at home so that is why I didn't post it in the first place. I wanted to get the corrections made before my staff gets to school in the morning. Which is going to give me about 1.5 hours to work on it. When I get to school I will post it.