trying to add list of worksheets to actual worksheets just like this youtube video

Hi There,

attached is my spreadsheet, and under the title"breakdown" is a list of worksheets i need. I have displayed the worksheet "mainswitchboard"and that is what i want every work sheet to look like.

is there a way to list all of the worksheets i want first on the summary, then hit a macro and it will automatically make those worksheets? I have made a button up on the summary so when i hit that button is when

i want the worksheets to be made.

I also need all the totals in each worksheet to be automatically added to the rows under the breakdown sheet, is this hard?

http://www.youtube.com/watch?v=ppg4Wk1GLb0