Jan,
Thanks very much. This works very well, and I learnt a new function
(ISERROR) along the way!
Sue

"Jan Karel Pieterse" wrote:

Hi Sue,

One possible solution I wondered about, was that if I listed after each team
name on Sheet 1 upon which one of the following three sheets the match would
be found, could I then move to the appropriate sheet before starting up
Stef's part of the macro.

You could try without a macro (if there are not too many this should work OK).

Suppose the names are on the worksheets Sheet2, Sheet3 and Sheet4 (and you're
in worksheet Sheet1), on each worksheet in the range $A$2:$A$100.

This formula will create a direct, dynamic link the first worksheet (and cell)
that name (that is in cell A2 ) is found in:

=HYPERLINK(IF(NOT(ISERROR(MATCH(A2,Sheet2!$A$2:$A$ 100,0))),"#"&ADDRESS(MATCH(A2
,Sheet2!$A$2:$A$100,0)+1,1,,,"Sheet2"),IF(NOT(ISER ROR(MATCH(A2,Sheet3!$A$2:$A$1
00,0))),"#"&ADDRESS(MATCH(A2,Sheet3!$A$2:$A$100,0) +1,1,,,"Sheet3"),IF(NOT(ISERR
OR(MATCH(A2,Sheet4!$A$2:$A$100,0))),"#"&ADDRESS(MA TCH(A2,Sheet4!$A$2:$A$100,0)+
1,1,,,"Sheet4"),"Not Found"))))

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com