Private Sub Worksheet_Activate()
Dim Sh As Worksheet, Derlg&
Application.ScreenUpdating = False
Range("b2.e" & Rows.Count).Clear
For Each Sh In ThisWorkbook.Worksheets
If Sh.Name <> ActiveSheet.Name Then
Derlg = Sh.Cells.Find("*", , , , xlByRows, xlPrevious).Row
If Derlg > 1 Then Sh.Range("b2:e" & Derlg).Copy Range("b" & Cells.Find("*", , , , xlByRows, xlPrevious).Row + 1)
End If
Next
End Sub