Macro to change a Pivot Table

[David M]

Hopefully a simple one- for someone!
I want someone to choose a name from a list on a sheet
When they hit the macro button I want that name to be used to filter a pivot
table on another sheet.

Anyone any ideas?

Thanks hopefully,

David.