Drop Down Combo Menu Link to Pivot

I have a need to link a drop down/combo box to a pivot table
and would appreciate any ideas or techniques to get this done.

Sheet2: This sheet has all the line item details. For instance, A2 =
Country, B2= State , C3 = City, C4 = blah blah blah .. approximately
12 columns.

In sheet3, I've pivoted the data in sheet2 so that in the PAGE section
of the pivot are 3 options (Country, State and City).

In sheet1, this is where I have the 3 combo menu corresponding to the
3 options on the pivot in the same order (Country, State and City).

How can I change the PAGE selection of the pivot through the combo
menus in sheet1? I know I can leave it at pivot page and be done but
my clients aren't very pivot crazy and they've specifically asked for
drop down menu instead.

I would imagine this would require some VB scripting. Unfortuantely, I don't now much about VB so including simple steps would be very beneficial. Much thanks.

Matt