Creating a script to insert data into excel spreadsheet

[eeeevl]

I am wanting to create a spreadsheet that automatically inserts data from one (workbook) sheet into another template. This template would need to have the data from the table below (Fitness Testing) inserted and sorted into the next table which ranks in order of score (highest to lowest) (Survival of the Fittest)... Hope that makes sense...

Fitness Testing

Flexibility

Muscular Power

Muscular Power

Muscular Strength

Muscular Strength

Muscular Endurance

Aerobic Endurance

Speed

Agility

Sit&Reach (xx)cm

Standing Long Jump (xxx)cm

Vertical Jump (xx)cm

Hand Drip Dynomometer (Grip Strength) (xx)kg

30 Second Pushup Test (xx)

60 Second Situp Test (xx)

Multistage Fitness Test (beep test) (xx.x)

50m Sprint (xx.x)sec

Illinois Agility Test (xx.x)sec

Score

Rating

Score

Rating

Score

Rating

Score (Left)

Rating (Left)

Score (Left)

Rating (Right)

Score

Rating

Score

Rating

Score

Rating

Score

Rating

Score

Rating

Poor

Poor

Poor

Poor

Poor

Poor

Poor

Poor

Excellent

Excellent

Poor

Poor

Poor

Poor

Poor

Poor

Poor

Poor

Excellent

Excellent

Poor

Poor

Poor

Poor

Poor

Poor

Poor

Poor

Excellent

Excellent

<colgroup><col span="2"><col span="2"><col span="6"><col><col span="3"><col span="2"><col span="4"></colgroup><tbody>
</tbody>

Survival of the Fittest

Name

Flexibility

Name

Muscular Power

Name

Muscular Power

Name

Muscular Strength

Name

Muscular Endurance

Sit&Reach (xx)cm

Standing Long Jump (xxx)cm

Vertical Jump (xx)cm

30 Second Pushup Test (xx)

60 Second Situp Test (xx)

Sam

Jones

21

<colgroup><col><col><col span="2"><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col span="2"><col><col><col><col span="2"></colgroup><tbody>
</tbody>