Pivot tables autofilter

[INDENT]On sheet 1 i filtered my database on "vendor list". On sheet 2 i created a pivot table in which "vendor list" is set as a field. I wished that if i select and filter out a particular value from "vendor list" in sheet 1 ,the "vendor list" field on sheet 2 will automatically filters out the same value . Is this possible?
If someone can provide me with the right code i will be veryyyy thankful.

Thank you for your answers.
[/INDENT]

Re: Pivot tables autofilter

I am not supposed to touch the pivot table. I have only access to the master table filter and i have to control the data in the pivot table from that master table (sheet 1).

any new suggestions??