Macro to Add Worksheet to Workbook

Hello,

I am in need of some help. I have taken very basic VBA class so understand a little (very little) and would appreciate any help anyone could give me.

I have a couple of questions, but will start with just one at a time and try to solve the other issue on my own prior to asking the question.

My first question has to do with creating a macro that will create a new page in a workbook based off of a "VeryHidden" template. I am using a 3-D formula to add totals to a summary sheet, so I want to be able to add the new sheet between my beginning sheet and ending sheet for my formula. It would also be helpful if I could add the tab name to the sheet at the same time and have it fill in cell B2 at the same time.

I appreciate any help and/or pointers anyone could give me on this.