Your life would become a lot easier if all the data were in one worksheet. You
could add another column to indicate the month (and year) and then use
data|pivottable to get very nice summaries.

Vijay Joshi wrote:

I have the productwise data of sales in different sheets. The sheets are the
basically the months. The products are categorised according to their end
use. e.g. TV, Music system will be classified as Electronic goods, where as
cricket bat, football will be categorised as Sports material. These details
are available Sales staff wise.
I want to have the output file with details of sale employee wise, monthwise
& categorywise.

--

Dave Peterson