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.