How to copy data from two workbooks and append to another workbook?

When you run the script, does it open workbook 1 and 3?
If both workbooks open, ensure that the sheet names reflect what you indicated in the code.

I will get back to you as I need to test your version of the code.

I need to open two workbooks that need to be imported into the original workbook. This means workbook 1 and 2 have file names that are always not the same but are in the same format. i.e Workbook 1 could be named "Workbook 1 (2)" and the next day it will be named "Workbook 2 (3)". I'm basically trying to import it using the dialogue prompt.

Please let me know how to get past this error