这样修改比较好
Sub ayy2()
Application.ScreenUpdating = False
Sheet14.Range("A2:D65536").Clear
For Each sh In Sheets
If sh.Name <> Sheet14.Name And sh.Name <> Sheet1.Name And sh.Name <> Sheet13.Name Then
LRow = Sheet14.[C65536].End(3).Row + 1
With sh
.Range("A2:C" & .[C65536].End(3).Row).Sort Key1:=.Range("A2:A" & .[C65536].End(3).Row), Order1:=xlAscending, Header:=xlGuess
ARR = .Range("A2:C" & .[C65536].End(3).Row)
End With
If ARR(1, 1) <> "返回目录" Then
Sheet14.Range("A" & LRow).Resize(UBound(ARR), 3) = ARR
Sheet14.Range("D" & LRow) = sh.Name
End If
End If
ARR = ""
Next
Sheet14.Range("D2:D" & Sheet14.[C65536].End(3).Row).SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=R[-1]C"
Sheet14.Range("D2:D" & Sheet14.[C65536].End(3).Row).Value = Sheet14.Range("D2:D" & Sheet14.[C65536].End(3).Row).Value
Application.ScreenUpdating = True
End Sub