So what you are trying to do is grab a worksheet from another workbook and
put it in the new workbook... or are you just trying to insert a new
worksheet?

the former.
i will use one spreadsheet as a template.
open the template spreadsheet, create a new spreadsheet and copy the
template into the new spreadsheet.
the code will detect if i need to add other template worksheets into the
newly created workbook.

"mcnewsxp" wrote:

i need the VBA code to insert a worksheet that is used as a template into
another workbook. the code may include 1 or more insertions of different
templates so i 'd like to get them on sequential wortksheets within the
workbook.
tia,
mcnewsxo