Report Duplicate Text from Multiple Worksheets

[Hodg100]

Hi

I want to find a neat way of finding and reporting Duplicate Text, across multiple Worksheets (maybe around 100), in a single Workbook.

The Worksheets are all identically formatted and contain text based Document references, e.g. VG-LM-General-XXX.docx in the Document Reference Column (Column B).

I would like for the report to list which worksheets contain any duplicated Document References from that column; so 'simply' two columns, one for the Document references and the other to show in which Worksheets they appear.

Is that possible using VBA or can it be achieved with the built-in toolset?

Thanks in advance

 

[Hodg100]

Bump