Sub merge()On ErrorResumeNext
Application.ScreenUpdating =False
Application.DisplayAlerts =FalseSet st = Worksheets.Add(before:=Sheets(1))
st.Name="total"
i =1For Each shet In Sheets
If shet.Name<>"total"ThenIf i =1Then
shet.Range("A1").CurrentRegion.Copy Destination:=st.Range("A1")
i = st.Range("A"& Rows.Count).End(xlUp).Row +1Else
shet.Range("A2").CurrentRegion.Offset(1,0).Resize(, Columns.Count -1).Copy Destination:=st.Range("A"& i)
i = st.Range("A"& Rows.Count).End(xlUp).Row +1EndIfEndIfNext
Application.DisplayAlerts =True
Application.ScreenUpdating =True
MsgBox "finish"EndSub