Changing Pivot Report Filter based on Drop Down List Selection

Hello,
I am a fairly newbie to excel macros. Following is what I am trying to accomplish.

1) Sheet named "Customer_Master"'s cell J2 has a list of customer names.
2) Sheet named pivottable - has a report filter "Customer_Name".

My requirement is when I change make a selection from the drop down list available in Customer_Master Sheet, I need the pivottable's report filter to change to the same automatically.

I've attached the excel sheet for your reference. In short, PivotTable.B1 should be the same as the value of Customer_Master.J2

Thank you for your help in advance. Look forward to your support.

I've tested the following and it works:

Customer Master Worksheet code:

Please Login or Register  to view this content.

In a Code Module:

Please Login or Register  to view this content.