Create a pivot table template/master copy?

Hello
Is there a way to create a pivot table template or master copy so whenever I alter the data this template is automatically updated in the format I have set up previously or do I have to buy a special package to do so? It is for MS Excel 2007.
Most of the data comes from the use of drop-down lists.
I've been told just to refresh the table but I've tried this in many ways and for some reason it didn't work.
I have attached a test sheet. The pivot table doesn't look brilliant, I am completely new to this and have to create something in the next day or so.

I hope you can help me.

Monique

Hi,

see attached ...

HTH

Thanks for this Jean
I changed some data and refreshed the table and it worked.
Great.
Much appreciated.
Monique