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