Cell References Change When Inserting From Top Row

Hello -

I am using the sum and count formulas in sheet A to pull data off sheet B in the same workbook.

In sheet B, I enter new rows of data, and do so by using a macro which inserts a row at the top (under the headers).

Every time I do this, the cell references change. For example, it will go from:

SUM(B!$E$2:$E$10000)

and will change to:

SUM(B!$E$3:$E$10001)


Can anyone tell me how to change it so that is stays like the first example? I've searched and all I could find is the "$" thing I put in, but it doesn't help. Thanks.

NEVERMIND!

Found the INDIRECT function.