I'm trying to identify duplicated values (text; specifically, it'll be file names) in a large workbook that has lots of sheets in it (about 20). I understand that It's pretty simple to do this when all the data is on the same sheet, and I think I can figure this out for myself. But does anyone know of a simple way to do this across multiple sheets. Alternatively, I suppose the data could be copied into a single sheet (the info is formatted the same on each sheet, so the column with the file names is always in column G). Since this is across 20 or so sheets, is there a way to automate this? So to summarise, I'd like to find out how to either:

1: Identify and highlight duplicates across multiple sheets.


2: Automatically consolidate several sheets into a single sheet.

Thanks a lot!