Question: how to automatically import data into excel from another excel file?
Answer: Click on the Data tab, then Get Data > From File > select From Workbook. If you don't see the Get Data button, click on New Query > From File > select From Workbook. ... 
In the Excel Browse dialog box, browse for or type a path to the file that you want to query.
Click Open.