Sub TEST() Application.ScreenUpdating = False For Each ST In Sheets ST.UsedRange.Offset(1, 0).ClearContents Next MyPath = ThisWorkbook.Path MYFILE = Dir(MyPath & "\*.xls") Do Until MYFILE = "" If MYFILE <> ThisWorkbook.Name Then Set FS = Workbooks.Open(MyPath & "\" & MYFILE) For I = 1 To 3 With FS.Sheets(I) .Range("A2:D" & Range("A65536").End(3).Row).Copy ThisWorkbook.Sheets(I).Range("A65536").End(3)(4) End With Next FS.Close End If MYFILE = Dir Loop Application.ScreenUpdating = True End Sub