Separating Data by Reporting Structure in PQE

Hello! I hope I'm able to describe what I need help with with enough clarity, but I will answer any follow-up questions to the best of my ability. I'm still very much a beginner when it comes to Power Query, so I'm feeling around in the dark here.

I have been asked to create some reports for each of my company's VPs. I have the data I need, I would just ideally like to have a sheet in the workbook for each VP. The employee data I get from my company's HRIS has 6 Supervisor Level columns, so I need to somehow check each of these 6 columns for a given VP's name and pull any returned results into their own sheet. Can I create some kind of lookup table for this so that if a VP for a given department changes i can just update the table and not break the query?

Please help me, kind Excel wizards.