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