I have a workbook in which a Summary worksheet accumulates data from a Detail
worksheet. Quite often I need to have extra Detail worksheets which I create
using [hold Ctrl key down, Edit, Move or Copy worksheet, Copy worksheet] as
many times as I need detail worksheets. This renames each copy and updates
all links in the Detail worksheet.

But now I have to manually update the Summary worksheet. ie.
Summary.Total = Detail 1.Subtotal + Detail 2.Subtotal + Detail 3.Subtotal
etc. etc.

Is there a way to dynamically update the cell formulae in the Summary
worksheet to link to the Subtotal cells in the Detail worksheets, as and when
I make new Detail worksheet copies.

I have tried to find a way in Excel functions and also using VBA macros, but
can not find a way to achieve it.

Anybody have any suggestions??
Thanks in advance.