Calculating totals from user added worksheets

Heres a new one

(REWROTE THIS POST TO MAKE MORE SENSE)

I have a workbook with 5 tabs (1,2,3,4,5) Tab 2 is hidden

The user enters data into tab 3 and there is a totals column on Tab 3, if the user fills up the the coulmns on tab 3 then they can unhide tab 2 using a custom menu.

At the moment as this tab(2) is hidden the formula on tab 3 totals columns inculdes the data on tab 2

Keeping up with me so far

Now i need a function that will allow the user to add a new sheet which would be a copy of tab 2 (infront of tab 2) and give it an automatic name ie 2.1 and then the totals on this new sheet to be included into the totals on tab 3

But also the user can add anmany tab as they want, to be name after the previous i.e 2.2, 2.3, 2.4 etc, they need to be place in front of the previous sheet and again the totals on this sheets to be added to the totals on tab 3

I hope that makes more sense...