VBA to Call Multiple Macros

Originally Posted by Norie

Nothing that I can see but that code is opening a lot of other workbooks and it is possible that there's code in one of those workbooks causing the problem.

This is a bit of a long shot but might be worth a try, at the start of Macro1 disable events.

Application.EnableEvents = False

Don't forget to enable events at the end.

Application.EnableEvents = True

Thanks Norie,
I ran the macro as you suggested and acheived the same results.
As for the code in the merged workbooks, here is a copy of the only other macro in that directory:

Private Sub Worksheet_Change(ByVal Target As Range)
 With Target
  If .Count > 1 Then Exit Sub
  If .Column = 5 Then
  If Target = "" Then .Offset(, -4).Resize(1, 4) = ""
  If Target >= 1 Then _
     .Offset(, -4).Resize(1, 4) = _
     Array(Split(ThisWorkbook.Name, ".")(0), Date, [C2], [D2])
  End If
 End With
End Sub

See anything in there?
This is quite perplexing!

Thanks!