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.