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