Question: how to copy all excel sheets?
Answer: Open the source and target workbooks.
On the View tab, in the Windows group, click View Side by Side. ... 
In the source workbook, click the sheet tab you'd like to copy, hold down the Ctrl key and drag the sheet to the target workbook.