Combining data from multiple sheets into one Pivot Table

[kgleng]

Hi,

Would like to find out if there's a way to combine (add up) data from multiple sheets on a same Excel file and have them displayed via a Pivot Table. The data consists of same categories with value or info which varies according to project. 

Attached is an example file. The Pivot Table created  in the Excel file only has the value from 1 sheet.

Thanks. 

[#2]

@kgleng Combining multiple tables/ranges into one pivot table is not possible in Excel for Mac. On the Windows version you could achieve it, though. And having said that, your data isn't really suited for analysis with a pivot table. It's already cross-tabulated and you include empty rows.