Sub 按钮5_单击()
Dim i As Long
Dim j As Long
Dim c As Byte
Dim str As String
str = [n3] & [p2]
j = 4
For c = 2 To ThisWorkbook.Sheets.Count
If InStr(1, str, Worksheets(c).Name) > 0 Then
i = Worksheets(c).UsedRange.Rows.Count
If i > 4 Then
Worksheets(c).Rows("5:" & i).Copy
Worksheets("报名册").Range("A" & j).Select
ActiveSheet.Paste
j = j + i - 4 + 1
End If
End If
Next
ThisWorkbook.Save