I didn't think it was possible, but you first pull up the P-T wizard, there
is an option, "multiple consolidation ranges". This will allow you to do
what you wish to do. I ran through it. It is pretty self-explanatory. Good
luck.

"Terry" wrote:

Is it possible to use a pivot table to combined mutable work sheet in
different folders?