I have a Workbook with about 30 sheets in it. I have 5 Summary pages that sum and calculate different pieces of the data that are collected on the other 25 sheets (which are identical btw and the starting sheet is A and ending sheet is Z. Both of which are blank, just there for clean formulas.) When I insert a row on the 25 sheets (grouped together) y formula on the summary pages does not reflect the fact that I inserted a new row, so anything calculated below it is off 1 row. (or as many as I inserted.)

Using the $ does not seem to have any effect on the formula either.

Here is what I have:
=SUM(A:Z!D146)+SUM(A:Z!E146)

So if I insert a row above 146, my formulas on the summary page looking at 149 are now off. I'm sure this is a simple fix, but I can't find an answer.)

Any help is appreciated.