one way:
open each workbook and right click on the sheet name you want. copy or move
then select a new workbook and make a copy.
HTH

"Madcat" wrote:

I have several worksheets using same template for excel, how do I form one
workbook and import all these seperate sheets into it??