Single Pivot Table 4 Multiple Sheets?

F

FARAZ QURESHI

I have four sheets showing a performance of four different zones in selling
different brands. All the sheets are of the same format. Is it possible to
have a single Pivot table to summarize them all into one?
 
F

FARAZ QURESHI

Thanx Peo,

It was a good link!

However, there's a problem. The exactly same columns in 2 sheets are:
Branch Product Amount Units

Now only want to consolidate in the format as:
Sheet1 Product-A Product-B
Branch-A Amount Amount
Units Units
Branch-B Amount Amount
Units Units

But the Consolidation ranges result in a format of a pivot table as:

Branch-A Sum of Product Sum of Amount Sum of Units
Branch-B Sum of Product Sum of Amount Sum of Units

Any idea, How 2 "customize" the layout for further clarification of fileds
rather than only having three fields of row, column & value?

Thanx again
 
Top