Hi all. I use Pivot tables quite frequently to do consolidations.
Since I frequently consolidate up to 100 or more workbooks at a time
it's kind of a pain to enter all of the ranges separately in step 2b
of the Pivot Table Wizard. I'm thinking there must be a way to maybe
use VBA to: 1) Enter the ranges to consolidate without me having to
manually enter. 2) Construct the Pivot Table. I'm a novice at VBA
and I did use the recorder to see if I could figure the necessary code
on my own but I'm at a standstill.

Can anyone point me in the right direction?

Many Thanks
Andrew