Hi NoSparks, now I understand what you meant with the following:
ActiveWorkbook is the last workbook opened by the OpenUpFiles macro and
ActiveSheet will be the sheet that was active at the time that file was last saved.
This part of the below code was the problem.
Code:
' Change worksheet designations as needed
Set Source = ActiveWorkbook.Worksheets("Summary")
Set Target = ActiveWorkbook.Worksheets("Sheet1")
Here below are the changes made to the code.
Code:
' Change worksheet designations as needed
Set Source = ThisWorkbook.Worksheets("Summary")
Set Target = ThisWorkbook.Worksheets("Sheet1")
Now the macro is running all the way to the end.
Again, thanks for the suggestion.