'你可以把你发的那个例子中名字为“2021”那个工作表的名字改成“标准表”,运行这段代码试试看看
'不能上传附件太麻烦了
Sub 筛选()
Dim ws As Worksheet, rng1 As Range, rng As Range, a%
Set rng = Sheets("标准表").Range("a1", [a1].End(xlToRight))
For Each ws In Worksheets
If ws.Name <> "标准表" Then
ws.Activate
For Each rng1 In rng
a = ws.Range("1:1").Find(rng1).Column
ws.Range(Cells(2, a), Cells(Rows.Count, a).End(xlUp)).Copy Sheets("标准表").Cells(Rows.Count, rng1.Column).End(xlUp)(2, 1)
Next
End If
rng.Copy Sheets("标准表").Cells(Rows.Count, "a").End(xlUp)(2, 1)
Next
Sheets("标准表").Activate
End Sub