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.