I have 13 spreadsheets that contain 4 weekly salary information. I have
another sheet (YTD) which using absolute cell references from the other 13
sheets basically give a running total and then compares these to Budgets.

The problem I have is if I add/delete rows in any of the 13 main sheets,
then the totalling does not work due to the absolute cell references. I have
to subsequently change these references to pick up up the new absolute cell
references. Is there a way that will allow me to add/delete rows in the 13
sheets and automatically adjust the absolute cell references?

If the answer is No, then is there any other functionality within Excel that
can be used?

Any help given would be greatly appreciated.