Finding Data from Multiple sheets

[Guest]

Hi
I have a spreadsheet that contains the following:
Rows = Products
Columns = Months
Data = how many products sold in each month

This data is replicated on numerous sheets, each sheet is an individual
client.

I need to look at the products sold over each month, for each customer and
identify - who sold the most per month? Ideally creating a list of the top
ten customers.

I have tried copy and pasting data from each sheet into one and used this as
a database to create a pivot table, but the whole process of copying and
pasting each clients data takes so long to do.

Any advice would be great

 

[Guest]

With a Totals row on each sheet you could either set up links on the
Compilation sheet, one row for each sheet. Then, as the sheets are updated,
your compilation sheet will be updated automatically.

You can then have autofilters set up to do your identifying the top ten etc.

Once you have set up links to the first sheet, copy and paste that one down
the rows for as many sheets as are populated. Highlight each following row
and do a Find/Replace on each row to assign the links. This operation will
take a little time but will save a lot of time afterward.