Pivot table - consolidation range
 

Hi

There is a possibility in excel to add a pivot table for data from multiple
sources. At some point, when setting the pivot table with a wizard, there is
a listbox with all the sources. I need to somehow get the items from that
list, in other words, I need to get the list of all the sources the pivot
table retrieves data from?

How can I do that?

Kind regards
Igor M.