Pivot Table selection based on Drop Down

ETA: I solved it myself by changing the code to the following:

Please Login or Register  to view this content.

I have the following code which is supposed to select a page value based on what is selected in cell B6 (a validation list). But it's not working...it's just doing nothing. It's working on one Pivot Table that only has one Page Field, but this table has 2 and it's not working:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Post a sample file which demonstrates the problem at hand / in action.

Finally got it down to the right size.

I need this to do 2 things:

1. When the date in cell B3 is changed, the Anniversary Date Page Field needs to change to the month shown in G3.

2. When the VP is chosen from the validation list in B6, the VP Page Field needs to change to match that VP's name.