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

Thanks,

Steve