Filter Pivot From List

I have a pivot created by another team, using remote source data. For each member of my team I need to run a series of macros to configure the pivot the way they need it. Each member has 3 to 12 different DeptIDs, and each DeptID has 20 to 50 Programs (PACs).

There is no "Member" field in the pivot, only DeptID and PAC to limit the data. So, in my workbook I have a sheet ("DivPAC") listing each member in column 1, with their DeptIDs in column 2 and PACs in column 3, as shown in the picture.

My team members select their name at the start of the process. What I'm trying to figure out is how, during my manipulation of my pivot, I can use the name they input to filter my pivot to their data. I'm looking online but not having much luck, so would appreciate any help you can provide.