Need some real help w/Formulas HTML examples

[PAPSTISY]

My work book has the below worksheets. Basicly the spreadsheet is suppose to work as follows:
Member would enter their line-up on the players entrys worksheet. The players names would then transfer over to the Commisioners worksheet and Players Points worksheet.
The league Comish would then select from the pull down, the approprate stat for that given player/catagory which would be done on the Commisioners worksheet.

Here is where I need some real help with formulas! Once the Comish made the selection from the pulldown that particular selection would grap the appropriate point value located on the Players Stats page. The number value on the Players stats worksheet would then transfer to the appropraite player/catagory/point value on the Players Points worksheet.
I believe I need two more formulas to do this.
1. in the pull down window so it pulls from the Players Stats page
2. in the appropraite cell on the Players Points page so the value is retrieved.
There might be more but not sure?
I have tried working formulas through excel help and had no luck I messed with Input values and everything. Maybe it's just to complicated for me.
Anyway if someone could work the needed formulas I could then view and learn and compair to excel help pages. Eventually I would then understand how it's accomplished.
Your extra, kind help would really be great! Below are the html worksheets showing only one player position.
I look forward to everyones input.

Player Entry worksheet

FantasyHelp.xls
	A	B	C	D
3
4			Player Name
5
6			QuarterBack
7	Team 1	QB	McNabb
8	Team 2	QB	Caulpepper
9
PlayerEntry

Players Points worksheets

[weird portion of code removed]

Players Points

FantasyHelp.xls
	A	B	C	D	E	F	G	H	I	J	K
5
6			Player Name	Rushing TD Points	Rushing Yard Points	Passing TD Points	Passing Yard Points	Field Goal Points	Defense Points	Interceptions Points
7	Team 1	QB	McNabb
8	Team 2	QB	Caulpepper
PlayerPoints

Commisioners Worksheet

FantasyHelp.xls
	A	B	C	D	E	F	G
5
6			Player Name	TouchDowns	Rushing/Receiving Yards	2 PT Conversion	Passing Yards
7	Team 1	QB	McNabb	Select One	Select One	Select One	Select One
8	Team 2	QB	Caulpepper	Select One	Select One	Select One	Select One
9
Commisioner

Players Stats worksheet

FantasyHelp.xls
	A	B	C	D	E
6
7		Criteria		Description	Value
8
9		Rushing		>99 yards	2
10		Receiving	-------------	>124 yards Rush or Receive	3
11		Yards		>124 yards Rush & Receive	3
12		Criteria		>149 yards Rush or Receive	4
13				>149 yards Rush & Receive	4
14				>199 yards Rush or Receive	5
15
Pointstat

Thanks Every one for their time!
Jason

Edited by Von Pookie