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.