How can I automatically update formulas when new sheets are added?

[Apollo6]

I have a workbook, sheet(1) is the "Total" sheet. Let's say there are 3 other sheets in the workbook, each a different person. For example:

Sheet(Total)
Sheet(ID1)
Sheet(ID2)
Sheet(ID3)

The (Total) sheet has formulas that total up all the other sheets, for example cell Totals!B4 has a formula:

=ID1!B4+ID2!B4+ID3!B4

I have written some code that prompts a user to enter the new sheet to be added. It moves that value into a variable. Then creates a new sheet, naming it the variable.
It also does moves the new sheet to where it should be alphabetically.

What I want to do through VBA, is to update the Total sheet formulas to have the new sheet added to the existing formula to where it would now look like:

=ID1!B4+ID2!B4+ID3!B4+ID4!B4

ID4 being the new sheet added to the workbook.

Any ideas?!?!?!

 

[Apollo6]

Little tricky but figured it out, thanks anyway!!!