Question: how to copy multiple excel sheets into one workbook?
Answer: Open the workbooks you wish to combine.
Select the worksheets in the source workbook that you want to copy to the main workbook. ... 
With all worksheets selected, right click on any of the selected tabs, and then click Move or Copy….