Inserting Rows Doesn't Adjust Formula on Summary Page

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.

If you're saying you want the references to remain fixed (ie always refer to D146 irrespective of rows being added / removed) then I'm afraid using 3D referencing you have a problem as you can't use INDEX and INDIRECT won't work without use of SUMPRODUCT... you would need something like:

=SUMPRODUCT(SUMIF(INDIRECT("'"&CHAR(64+ROW($A$1:$A$26))&"'!D146"),"<>0"))-SUMPRODUCT(SUMIF(INDIRECT("'"&CHAR(64+ROW($A$1:$A$26))&"'!E146"),"<>0"))

Given the use of INDIRECT the above becomes volatile I'm afraid... lots of Volatile SUMPRODUCTs is generally a bad idea.

You might be better off creating summary sheets the conduct calcs against each sheet and simply sum those results, eg:

=INDEX('A'!D:D,146)-INDEX('A'!E:E,146)

would give the value for A in a non-volatile form which would not alter as rows / added removed (assumes Columns D / E never removed entirely) ... repeated for each sheet the sum is your final result.
Less elegant but arguably more efficient (and straightforward) long term.