Extract values from PIvot Tables through the use of Excel's GetPivotData function.
This video is immediately available with an Excel Fans subscription