Hi Skudera,
This is far more than you are asking, but it sounds like something that may interest you. Here is my blog on creating reports in XL from databases. It includes a routine to create pivot tables donkeyote proposed and you have asked for:
Beyond Excel
Bookmarks