Open the destination worklbook and the source workbook. Then copy the source
worksheet by right clicking on the tab on the bottom of the worksheet
(normally sheet1) and select move/copy. then select the destination workbook
and the location where you want the new sheet. Then close the source
workbook and open then second source workbook and repeat the process.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.