Question: how to open multiple excel files in one sheet?
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….