In my workbook, I have varying numbers of worksheets, each with
numerical values in the A3 field. I then have a sheet which totals up
all the A3 values of each worksheet. My problem is that the number of
worksheets varies, and when I add/remove worksheets from a workbook, I
have to redo the sum function on the total sheet.

Can I make my total sheet automatically compute the A3 cells of all
other worksheets, no matter how many there are?

This may not have a solution other than manually doing it everytime,
but I'd very much appreciate any help.

Thanks!