Adding one row to a Sum function

[USAMax]

I wrote a function that scrapes data from a web site and adds one row just above the TOTALS row. That row has a sum function that for this example is:
=SUM(B121:B137)

But once I add one row it should be:
=SUM(B121:B138)

I have a LONG process in mind to address this but I am hoping there is a simple way to do this.

PLEASE NOTE: There may be gaps in the data so I need to use the highest row number from the formula.