You can create dynamic ranges for the data, and refer to those when
adding the multiple consolidation ranges. There are naming instructions
he

http://www.contextures.com/xlPivot01.html

sean wrote:
Problem with multi consolidation.

After a pivot table and chart are created, within the data ranges of the
source data more data is added but the data will not display upon refreshing
the pivot. Why is that?

So, having many worksheets using multi consolidation pivot, if any extra
data is added to the worksheets within the pivot source range, when
refreshing the pivot table/chart, that data will show up in the pivot.

This is a sticking point for the purpose required.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html