sorting columns from different spreadsheets in same workbook

[easybpw]

Here is my situation. I have 7 spreadsheets in 1 workbook. Each of the
first 6 spreadsheets are set up in the same format. In the first 6
spreadsheets column a represents a name and there are a list of names
from a:1 down to a:50 or so. then in columns B-F there is data in
them. Column H is a formula that totals all the data and leaves a
result. Again this is consistent with the first 6 sheets. What I want
to do is on sheet 7 have a formula or Macro that looks at the first 6
sheets and finds the top 5 highest totals from column H and puts the
results on sheet #7. The kicker is that I want the corresponding name
in Column A to be with the results. In other words if the name is John
in column A and John is the highest total from Column H then on sheet 7
I would like to have in Column A be John and Column B be the high total
from Column H from the first 6 sheets. Also in the first 6 sheets we
could have a name that is duplicate so I would want the Macro or
forumla to recognize duplicates and not post the duplicate on sheet 7.
Hopefully I explained that well enough for someone to answer.
Thanks!