You need to open both workbooks, activate the workbook to copy from,
select the sheet(s) to copy and Edit / Move or Copy Sheet / Create a
Copy / and nominate the workbook to copy to

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup