Question: how to open multiple excel files as sheets?
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….