Macro to create a League Table which will automatically update.

The enclosed file contains data which is added to on a daily basis. It shows work done by individuals on shifts. I would like to be able to show a League Table of the people which automatically updates based on the various columns. I have manually produced the stats for one individual on the sheet, but would like this to be produce for all the individuals automatically and shown in descending order based on AVGE % DONE. I have added some comments to help explain where the data comes from. Any help is appreciated. Kevin