search for string in another sheet, get cell number and put cells in first sheet

I am not sure what the exact term is but let me expane my issue.
I have 2 sheets in a workbook using Excel 2007.
the sheet # 2 (SM) contains data that each driver gets during th erace season and depending on the data thats entered the Rank will move, I use the Rank function.
on sheet # 1 (Ranking) I want to list the ranking in order. So here is the data.

Ranking
I have 20 drivers, each with scores, every race their times are entered
the sheet calculates their place or rank.

SM
I have a list of 20 drivers, each week as times are entered I would like the list to reflect
the data on sheet2.

Rank = SM!A28
Driver Name = SM!B27
points =SM!D55
Races = SM!D30

I tried this fuction but it will not list the Cell data

= MATCH(1,SM!$A$5:$A$500,0) in cell F2 in sheet1 contains the cell number 28

So waht I am doing here is looking for the driver who is in first place on sheet2
so I found the cell that contains the number 1.

Then I need to get the Driver name and put it in Cell A2

= SM!B + F1 -1

Then get the points in Cell B2

= SM!D + F1 +27

Then get the races in Cell C2

= SM!D + F1 +27

then repeat this for all 20 drivers

Are you sure you posted the right workbook? I don't see any Sheet1 or Sheet2 with data and the references you show in your post don't seem to coincide.

Please re-explain with proper correlations to the workbook.

Let's try....

In D7:
=INDEX('SM '!B:B,MATCH($B7,'SM '!$A:$A,0)-1)

copied down

in E7:

=INDEX('SM '!AG:AG,MATCH($B7,'SM '!$A:$A,0)+22)

and in F7:

=INDEX('SM '!AG:AG,MATCH($B7,'SM '!$A:$A,0)+6)

Do those work?