So at this point I am able to import both sheets into my workbook by using the single file from the PDF reader, but I can only copy the content of one sheet after importing in my workbook. If there are more than 2 sheets in an Excel workbook, the PDF reader will not be able to handle the extra content correctly. This is a strange issue, and it might cause problems with files not compatible with the PDF reader in future versions of Excel 2007, 2010, 2013, 2014. It is worth noting that if another workbook, called “Excel 2013”, is opened inside the PDF reader, the last sheet will be opened. You won't be able to use this workbook with your new workbooks if they contain more sheets. When you are working with a lot of multiple files, it is worth to have the option to convert your workbooks into a single PDF file. Step 4: Import the Contents of Your Workbook into Other Programs Importing multiple files into Excel — Google Groups It is possible to import multiple Excel workbooks into Microsoft Office Excel from the program which was not the original one opened. 1. Open the original file in MS Excel 2. Then choose “File > Make a copy...”. Then choose “Extension > Excel” in the bottom left-hand corner 3. Then choose “File > Open With > File Conversion...”. 4. You should now see this, which is the newly converted file. You can also import all sheets of your Excel workbook into Google Docs or any other spreadsheet software. Tips for working with Multiple Worksheets into a PDF File The first thing when working with multiple Excel sheets in Excel 2013/ 2016/ 2023 is to save the contents into a PDF file as the worksheets themselves and not the individual worksheets. You can do this by going to File>Export>PDF. The main difference between this method of saving the results and the one in the previous section is that in this version the PDF file name only contains the name of the sheet. So, if you are working with a workbook with 10 sheets, the file name will be 10_Sheet.xlsx. You do not have to go back to your workbook and do a whole thing about changing the file name. You can now save your PDF file as a single file containing all the worksheets into one file named 10_Sheet.pdf.