as an addition can a formula be used to create another worksheet with matching numbers from month.
example (hopefully)

i have 3 worksheets with numbers 1 to 10000 on each of them numbers 1,5,7 on sheet1, 2,5,7 on sheet2, 3,5,4 on sheet3. Can a 4th sheet be produced to show that 5 shows on all and only 5, or is this moving into macros required?