Question: how to transfer data from one excel workbook to another workbook?
Answer: Open the workbook that you want to move the sheet to.
On the Window menu, click the workbook that contains the sheet that you want to move. ... 
On the Edit menu, click Sheet > Move or Copy Sheet.
On the To book menu, click the workbook that you want to move the sheet to.