Summary sheet in effecient way
 

All

I have xls files each months of the year in a folder. I have made
pivot tables in each of the workbooks which is something like this

Clients SalesGroup Quantity

a group1 25
group2 10
a subtotal 35

b group2 10
b subtotal 10

c group1 5
group2 10
c subtotal 15


In this pivot table i have grouped the sales representatives for each
region.

Now I want to make a summary sheet for all the months.

This can look something like this:

Clients jan feb mar apr..................
a 35
west region 10
east region 25
b 10
west region 10

In the particular format i have group2 to be named as west region and
group1 as east region. The first row of Jan shows the total Quantity
for Client a. The pivot tables have the clients in the sorted ascending
order. The summary sheet should have the clients in sorted order and
each having three rows showing total,west region total ( group2), east
region total (group1). The clients in summary sheet can be added in the
client column in sorted order and correponding values as per the
pivot in the xls files. I have grouped the sales represntives in the
reverse order in my monthly xls files wheres in my summary sheet i
would like them to appear as west region for group2 and then east
region for group1.


I would like an efficient way of doing this as my excel does not
support pasting in autofiltered coloumns.


Thankue in advance for any suggestions.

Regards
Sumit