Folks,

I have 8 pivots set on one data set- on purpose, they are set up this way in
order to update a second excel data sheet for reporting. My pivots are set to
show 3 months of data- at least this is how I want it. I can refresh these
pivots no problem but I want the macro to re-direct the pivot every quarter.

I have is that i want to "hit a button!" and the marco will
1. recognise if there is a new quarter or not
2. If there is a new quarter to redirect the pivot to the new quarter raw
data sheet
3. If there is no new quarter sheet available to update then to just refresh
the pivot with the new months data.

Each quarter is held on a seperate sheet in a primary work book.

Is this at all possible or am I being wildly optimistic?! If this isn't
clear let me know and I will try to do a better job of explaining myself!

Thanks
Cass