Microsoft Excel 2002

I have 155 clients which I need to run Pivot Tables for! All with the same
pivot table layout.

Is it possible to run the Pivot table with the 155 clients as a Template
basically, then somehow delete or permanently hide the data leaving only one
client, so that I can save multiple copies for each of the individual clients?

Or can I set up a pivot table where I can automatically feed in parameters?
Client details are stored on an Oracle database!