OK well since my previous post, with the help of the forums, I have sorted a workbook out which counts the number of coloured cells on each sheet. I now need to transfer matching numbers (coloured) on all other sheets to a 4th.

I have a list of numbers (1 to 10000) on each of 3 sheets. I need to generate a 4th sheet which lists the the matching numbers on the other sheets

ie sheet1 has numbers 1,3,5 coloured, sheet2 has numbers 2,4,5 coloured, sheet3 has numbers 1,2,5 coloured. Need to generate a 4th sheet where the only number listed will be 5 as this appears coloured in all the other sheets

Any help will be most appreciated