I am looking for a macro that can help me filter the same names out of a table that changes.

Context: need to look at my team members (25 people) on a payroll report of 800+ that changes on a week by week basis. I currently download the report, create a pivot table with the data I need, then manually filter the same 25 people week after week.

Ask: a macro that filters the same 25 people no matter what the payroll report contains (my people will always be in there, but the rest of the payroll changes).

Thanks so much for your help!