VBA change pivot table source data?

Hi,

Is it possible to have VBA tell a pivot table to change the location of the source data after the pivot table has been created, or can that only be done by completely recreating the pivot table?

Here's the scenario... I have two databases in Excel, each feeding a different pivot table (and cache) that then feeds a bunch of charts. What I would like to do is to be able to change pivot tables source data/cache to the either database using VBA.

Lawrence