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.