Question: how to import multiple workbook in excel?
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….