I have a large excel workbook with 12 worksheets for the months. In these
worksheets are up to 150 names with log book violations listed (we are a
trucking company). there are actually 5 colums of information for each
driver. I would like to consolidate this information at years end to see who
the main violators are. Is there any way to consolidate this data across
multiple worksheets into one easy to read worksheet?