Hi,

I have a workbook with 3 tabs. The third tab uses the SUM function to sum
the values in tabs 1 and 2. It's set up so that the cell A3 in tab 3 looks
to cell A3 in tabs 1 and 2.

I need to add a row in all the tabs but the SUM function isn't recognizing
that I've added a row. It still looks at A3 when I need it to look at A4.

I have many such SUM functions to update and am looking for a better way
than manually changing the SUM functions.

Any ideas? Thanks in advance for your help!