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