Hi guys and gals, I'm really stumped with this one so wonder if anyone can help me out.

I have acquired a book containing c.12 worksheets of what can only be described as absolute garbage.

I want to check the number of times any of the words contained in a text string (distinct cell) in "master' sheet, match any of the words, in any of the text strings in each cell of a column of "second" sheet (non case specific) and return the cell reference of second sheet with the most matches.

Any ideas?

Thanks

G