I am taking information from sheet 1 in Excel to combine in Sheet 2
There are alot more columns the i show here but you get the idea

Date of service Repair Maintenance
Color Cut
1/1/5 10
1/3/5
30
12/1/5
40
11/1/5
90


i want to search this information and have it add up in sheet 2(november)
November Rev Collected
Repair
Main
Color 90
Cut

This will reoccur on each new sheet which will be the new month.

Please let me know if this is possible.

Thanks
Sally