Pivot Table selection based on Drop Down

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.