I am putting together a Workbook that tracks the performance of my sales
team. The work book has a seperate sheet for each salesman. Each sheet has a
column per week total for a 20 week period.

Which is not where the problem is, I have done all of this for each
salesman.

What i need to do is make a new sheet that does a couple of things,,,

It needs to list the total for each salesman in order of smallest to
largest, assign each position a point total and then send back to each
salesmens sheet a running point total....

A picture is worth a thousand words so here is a basic image.....(Picture
Columns)

week 1
Position....Salesman....Sales..........Points
1..............Tom...........100.00.......1
2..............Rick...........200.00.......2
3..............George......300.00........3

Etc