Question: how to copy data from one file to another in excel?
Answer: Right click on the tab that you want to copy, and then click Move or Copy…
In the Move or Copy dialog box, do the following: Under To book, choose the target file. To place a copy into a new workbook, select (new book). Under Before sheet, specify where to put the copy.