Copying Worksheets Between Excel Files
Don't forget that you can easily copy multiple worksheets from one spreadsheet to another. After selecting the worksheets that you want to copy, simply right-click on any worksheet and select Move or Copy:
In the 'To book' drop down menu, select the [open] spreadsheet that you want to copy worksheets to, and then select the position for them in the 'Before sheet' box.