Hi all.
Is there a way to filter two worksheets simultaneously?

I've recorded the following autofilter:

Sub FilterC()
ActiveSheet.Range("$A$3:$J$29").AutoFilter Field:=6, Criteria1:="<"
Sheets("Sum").Select
ActiveSheet.Range("$A$8:$F$13").AutoFilter Field:=1, Criteria1:="<"
End Sub

It's not generic enough to use for all instances of my desired goal. And
none of the books we have discuss this topic.

I.e., I want to select a filter criteria on one worksheet, and have it set
the identical filter on the other worksheet.

Thank you.