I have a worksheet where I use multiple named ranges (Excel 2003
)
=OFFSET(Sheet1!$G$1,0,0,COUNTA(Sheet1!$A:$A),1)

When I remove old data from Sheet1, with the exception of the column
headers, row 1, and add new data I have to update all my name ranges and it
is always the cell it references.

In the example above I would have to update the $G$1 because it would read
after I delete the data and add new:
=OFFSET(Sheet1!$REF!,0,0,COUNTA(Sheet1!$A:$A),1)

Is there a way to avoid having to update these every time I delete the my
old data and add new, it is time consuming to update all the ranges and they
are needed