look at these posts

http://tinyurl.com/4q2wl
http://tinyurl.com/5rodg
--
Don Guillett
SalesAid Software

"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.