Sub tt()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim i As Integer, sht As Worksheet
For i = 1 To Workbooks.Count
For Each sht In Workbooks(i).Worksheets
If Workbooks(i).Name <> ThisWorkbook.Name Then
Workbooks(i).sht.Copy before:=ThisWorkbook.Worksheets(1)
End If
Next
Next
Application.DisplayAlerts = ture
Application.ScreenUpdating = ture
End Sub
Sub tt()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim i As Integer, sht As Worksheet
For i = 1 To Workbooks.Count
If Workbooks(i).Name <> ThisWorkbook.Name Then
For Each sht In Workbooks(i).Worksheets
sht.Copy before:=ThisWorkbook.Worksheets(1)
Next
End If
Next
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub
Sub tt()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim i As Integer, sht As Worksheet
For i = 1 To Workbooks.Count
If Workbooks(i).Name <> ThisWorkbook.Name Then
For Each sht In Workbooks(i).Worksheets
sht.Copy before:=ThisWorkbook.Worksheets(1)
Next
End If
Next
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub