A = Sheet1.Range("a1").CurrentRegion
B = Sheet2.Range("a1").CurrentRegion
C = Sheet3.Range("a1").CurrentRegion
With Sheet4
.Range("a:f").NumberFormat = "@"
.Range("a2:f65536").ClearContents
End With
Set d = CreateObject("scripting.dictionary")
For i = 2 To UBound(C)
d(C(i, 1)) = ""
Next i
'表1
s = 0
ReDim x(1 To UBound(A), 1 To 3)
For i = 2 To UBound(A)
If d.exists(A(i, 3)) Then
s = s + 1
x(s, 1) = A(i, 1)
x(s, 2) = A(i, 2)
x(s, 3) = A(i, 3)
End If
Next i
If s Then Sheet4.Range("a2").Resize(s, UBound(x, 2)) = x
'表2
s = 0
ReDim x(1 To UBound(B), 1 To 3)
For i = 2 To UBound(B)
If d.exists(B(i, 9)) Then
s = s + 1
x(s, 1) = B(i, 1)
x(s, 2) = B(i, 2)
x(s, 3) = B(i, 9)
End If
Next i
If s Then Sheet4.Range("d2").Resize(s, UBound(x, 2)) = x