Sub ahmed()
Application.ScreenUpdating = False
Dim sh As Worksheet
For Each sh In ThisWorkbook.Worksheets
For r = 8 To 300
If sh.Name = "Sheet1" Then GoTo 2
If Cells(r, 5).Value <> Empty Then
If Cells(r, 5).Value = sh.Name Then
Range(Cells(r, 1), Cells(r, 13)).Copy
QQ = sh.Cells(1000, 1).End(xlUp).Row + 1
sh.Range("a" & QQ).PasteSpecial xlPasteValues
End If
End If
Next
2
Next
Application.CutCopyMode = False
Application.ScreenUpdating = True
End Sub