Hi

apart from the fact that doing this for 20 sheets is quite labourious - i
think Data / Consolidation (with all three boxes ticked) will give you what
you want (try it on three sheets first to see).

Cheers
JulieD

"Allan Skyner" wrote in message
...
I have a workbook with 20 sheets (countries) all formatted the same,
contained inj the sheets in cells A74;A90 are names of suppliers and the
same
supplier name could appear in any of those cells on any of the sheets.
I'm trying to build a summary sheet so I can select a suppliers name in
one
cell and then in various cells below the names of the countries (sheets)
appears.