VBA to filter pivot table from a cell reference in another sheet

[rickettsd96]

I want to be able to select from a list of clients in sheet1 A 1, which will filter a pivot table in sheet 2

I am completely new to VBA codes so please can someone help me with this.