I have 100 + worksheets which are all the same (except for the tab name they
are different per customer), one cell (the same cell for every sheet) has the
date that the customer is going to be renewed another cell has the customer
names and one cell has the amount paid for the products

I have a tally sheet that I want to break out per year to show which
customer will be renewed in 07 - 08 .... etc and their renewal date and what
they paid the previous year.

Any suggestions?

Thanks in advance



--
Neall