Macro for filtering names out of a table

[benj115]

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!

[PCI]

Send a file to illustrate how your data is and show what you need as final result

[benj115]

In the attached file are a list of names and random data about the names. I have created a pivot table containing the information I need, filtered by only the names I want to see. I can make a macro for this table no problem.

My problem: next week, my list of names will change, and I need the macro to filter the pivot table according to the same names as I filtered for in this table.

Many thanks

[benj115]

Here it is with an example of the next week's data