Question: how to import multiple excel files into excel on one worksheet?
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….