I created a worksheet with some formulas in it. I would
like to be able to add other worksheets at the end as
required using the copy command. I would be changing the
data in these new added-on worksheets. I need a "running
total" formula that will total specified cells from
existing sheets and incorporate the data from any new
sheet added at the end.

How can I do this?