Updating a pivot table

Hello,

My name's Richie. I am trying to set up a macro which will update a pivot table automatically with given values. I have a pivot table containing several fields of information about our customers. One of the fields is in fact Customer. On another tab, Customer list, I have a list of 5 customers. This list is not static i.e. the names change regularly. I want to run a macro that produces a report on these 5 customers. I need this macro to return the Customer name as per the names that are in the Customer list tab. In other words, the pivot table field Customer, is updated with the first customer name from this Customer list tab, the relevant values are returned & copied to a new sheet, then the pivot table is updated for the second customer name and so on in sequence.

Does this make sense I know how to do the simple part (i.e. copy, paste into new sheet etc. but not the pivot table update. Can this operation be performed what is the VB script

Thanks,

Richie