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