Multiple Range Pivot Table (Urgent Please)
 

I have 3 Sheets with same following headings in columns A to E, for 3
different products (X, Y, Z):

Case Branch City Segment Amount Qty

I want a consolidated Pivot Table as follows:

Page Field: (Products: X, Y, Z)

Columns: 1. Segment

Rows: Data:
1. Branch 1. Sum of Amount
2. City 2. Sum of Quantity

All your help is highly appreciated & obliged. It is once again requested
that urgent assistance may kindly be provided.

Best Regards!