Question: how to export data from one excel to another excel?
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.