How do I combine different worksheets into one book?

[Madcat]

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

 

[Ray A]

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