Question: how to import data from one excel spreadsheet into another excel spreadsheet?
Answer: Go to click Data > Connections, see screenshot:
And then choose the workbook that you want to export its data to current worksheet.
After choosing the workbook, please click Open button, and select one worksheet that you want to use.