I have seen some examples of creating worksheets from master templates.
Bue my situation is a liitle more complex.
Here's what I envision the final product to look like.

The workbook would have a number of different templates for various products (approx. 12). These would be hidden.

When you open the workbook, you would see a main page with some basic project information and a list of available templates [no tabs yet]. The user would select the templates he wants and how many of each. The macro would then create the number of appropriate worksheets [tabs] and arrange them in the order in which they were listed on the main page. The user would then go to each tab and start to fill out /update each one and save the workbook under the project name.

Any guidance or help would be greatly appreciated.
modytrane.