السلام عليكم
هذا الكود
Private Sub zz(ByVal Target As Range)
Dim Cel As Range
Dim LR As Long
With Application
.ScreenUpdating = False: .EnableEvents = False
End With
For Each Cel In Sheets("Mian").Range("A2:A" & Sheets("Mian").Cells(Rows.Count, 1).End(xlUp).Row)
On Error Resume Next
If Evaluate("=ISREF('" & Cel.Value & "'!A1)") Then
With Sheets("" & Cel.Value & "")
LR = .Cells(Rows.Count, 1).End(xlUp).Row + 1
If Application.WorksheetFunction.CountIfs(.Range("A2:A" & LR), Cel.Offset(0, 0), .Range("B2:B" & LR), Cel.Offset(0, 1)) Then GoTo Skipper
.Range("A" & LR).Resize(, 8).Value = Cel.Offset(0, 0).Resize(, 8).Value
End With
End If
Skipper:
Next Cel
End Sub