find matching values across workbooks

[scoreback]

Hi there,

I have 34 workbooks each with a column of numbers in, some numbers are the same & some are different (& other columns with different info in them) . I would like to find any numbers that appear in ALL the workbooks, and get a list of those numbers.

(see below example - this would be lists from 2 different workbooks & i want to find the numbers that appear in all workbooks - i.e. the green numbers)

Is this possible ? & if so how?

Thanks in advance,

Martin.

2736210071 2736210071
2736210072 3116229041
2736210090 2736210090
3116229551 3216281800
3116228931 3116270310
3116228962 3326292250