3. Now you can select whether you want to copy this worksheet to a new workbook or to an existing one. Select the one of your choice from the drop-down menu. Note: If you want to move your worksheet ...

When you attach an object this way, you can add all the content of an existing file, include a clickable icon linked to the file, or create a brand new file and then embed it in your Excel worksheet.

It may take you some time to scan the subfolder. Then select the files or folder. If you add a folder, you will see the windows to choose whether to scan Excel files in the subfolder or not. Step 2 ...

Insert the PDF file into a cell in the Excel worksheet by clicking on the cell then selecting the "Object" option from the "Insert" menu.