I have a template worksheet that has data on it that a user is required to
input. I also have a macro that makes a copy of the template worksheet. For
arguments sake, the copy of the template worksheet may be named "Bob", and
the user can then input information relating to Bob. An example may be, how
much money Bob has.

I then have a summary worksheet that summarises all of the data in the
individual worksheets that are created from the template. One of the cells
may sum the same cell on all of the worksheets in the spreadsheet that have
been created from the template worksheet.

I want to have the flexibility to create a new worksheet from the template
worksheet and have the summary worksheet automatically link in the
information from the new worksheet. So, the question is, once i have created
the new worksheet from the template and input the data relating to that
particular person, how can i have it link directly into some sort of summary
worksheet without having to go and change the formulas in the summary
spreadsheet each time a new worksheet is added.