I would like to come up with a way that when I change the department on the Position Request Form tab in G9 it triggers to change the filter in the pivot table to the same department in tab MPGCalculation in cell C5

I have provided the file. Is this possible?

Thanks so much.