This post is a follow up query to John Dawson's post of 10/28/2005, in which
he asked how to move the cursor from an individual item (eg one of a list of
football teams, arranged in alphabetical order) in a column of Sheet 1, to
the same item in a similar column on the next sheet. However, in the second
sheet the items are in a different order (eg this might be the league
positions of the teams on the first sheet).

Stef vey kindly provided the following macro which did the job perfectly:

Sub Teamfind()
Dim keresrng As Range
csapat = ActiveCell.Value
Sheets("Position").Select <== Change Position to the actual name of
2.sheet!
Set keresrng = Range("A2:A65536")
Rows(WorksheetFunction.Match(csapat, keresrng, 0) + 1).Select
End Sub

My question now is this... Imagine that ALL the teams are still listed on
the first sheet. However I need to move the cursor to the identical team
which is listed on any one of the following THREE sheets. Following the
above example, these could be three different football leagues. It is not
known which of the three sheets it is listed on, but it is only listed once
on one of the three sheets.

Can anybody help, please?

Yours,
Sue Sch