I have a financial model that occasionally has a large revision, where entire rows may be deleted. Natural this breaks any formulas referencing those rows. What are the easiest ways to prevent this?

This is a cash flow model, so it's a bunch of formulas running down the sheet for each month. Sometimes the formula broken will be something as simple as A1+A2+A3; and then column 3 is deleted because it is no longer relevant, and the formula becomes A1+A2+#REF!. These I can usually get around with find and replace.

Sometimes it's a bit more complex though, like if it's encased in a formula such as MAX or a XLOOKUP. I can't change these just by replace, I'd have to individually find each line and adjust the reference to the new reference.

The annoying thing here is that this is all manual work. There are hundreds of rows as well as other sheets which may reference these rows, and it's very hard for me to track which cells I'll break by doing this. Trace dependants isn't too helpful because when it's a range being referenced I'll have thousands of references technically.

Is there a cleaner way to do this?