I am trying to use the pivot table function on data from multiple worksheets
in the same workbook.
I selected "multiple consolidation ranges" when prompted for location of
data to be analysed.
I then chose data from 12 sheets having the same column headings (different
# of rows) and created the pivot table.
The problem is, the pivot table created shows the correct columns but shows
the count of values in these columns for each sheet.
I am trying to get the sum of values in each sheet.

Is this possible?