Sub Macro2()
On Error Resume Next
Dim arr, brr, d, i%, j&, s&
Set d = CreateObject("scripting.dictionary")
Sheets("表五").Activate
ActiveSheet.UsedRange.Clear
arr = Sheet1.Range("a2").CurrentRegion
For i = 3 To 6
brr = Sheets(i).Range("a3").CurrentRegion
For j = 2 To UBound(brr)
d(brr(j, 1)) = ""
Next
Next
s = 3
Sheet1.[a2].Resize(1, 7).Copy [a3]
For j = 2 To UBound(arr)
If Not d.exists(arr(j, 1)) Then
s = s + 1
Sheet1.Cells(j + 1, 1).Resize(1, 7).Copy Cells(s, 1)
End If
Next
End Sub