yes their are a few and varied ways of doing this. but it really depends on
how your data is presented on the "months pages" and what you want to see on
the final report, are the 5 colums of data numbers of violations or text !!!
it really does depend on the current layout and what you hope to end up with

Rich


"Joe H" wrote:

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?