One way which should deliver it ..
In the 8th sheet,
you have sheetnames listed in A2 down, eg: violet
and listed in B1 across, eg: blue, green
In B2, normal ENTER to confirm:
=IF($A2=B$1,"",IF(SUM(INDEX(COUNTIF(INDIRECT("'"&$ A2&"'!A2:A1000"),INDIRECT("'"&B$1&"'!A2:A1900")),) ),"match in "&B$1,""))
Copy B2 across/fill down to populate. Modify the ranges to suit. Success?
hit the YES below
--
Max
Singapore
---
"Steve" wrote:
If I have a workbook with 7 sheets in it, e.g.
violet,indigo,blue,green,yellow,orange and red.
And data is in the A column of each sheet.
E.g. violet
1
2
3
4

blue
3
green
2
3

On an 8th sheet, I'd like some sort of table that will show when there is
matching data on the different sheets, something like this:

sheet names violet blue green
violet match in blue match in green

blue match in violet match in green
green match in violet match in blue