Knockout Draw Auto Fill

Hey I am part of a company that runs a school education program where kids race miniature F1 cars and part of it involves them to compete in a knockout tournament.

So I need to create a way in excel to have a Knockout Draw automatically fill itself in from data within the workbook.

Basically what I have is a bunch of columns with team name, then scores, then total and then their placing as shown below.

Team 1 | 5 | 10 | 7 | Total | Placing ie. First

What I am after is the formulas to use this information to autofill a knockout draw.

If any of you can assist me at all it would be greatly appreciated.

Any ideas anyone