Macro to create a new worksheet

[shelton1352]

I am putting together a workbook that is going to have multiple worksheets for calculating cost for construction estimating. I need to create a macro that will duplicate a specific worksheet (i.e. sheet 7) into sub sheets multiple times, and have a main sheet that will sum all of the information listed on the sub sheets created by the macro. I am not sure if this is possible, but any help is appreciated. Thank you

 

[texasalynn]

Welcome to MrExcel board...

we will need more information "create multiple worksheets" be determine how and what information would be on the sheet. The layout or something a little more definitive.

A suggestion is to turn on your macro recorder and go through the steps. Then you will have something that can then be modified to make it more generic and can be used repeatedly