(Solved) Rotating overtime list by hours?

I am trying to create an Excel spreadsheet for a rotating overtime list. I took a Microsoft Office Class back in the late 90's so please be gentle if my thinking is incorrect. I am using Excel 2007. The list has 10 persons labeled by their name. Each name has a number associated with it which represents their total hours of overtime. I have setup a workbook with 11 sheets so far. Each person has their own sheet where hours will be recorded. I have then linked their total hour cell to a master hours sheet. I would like the master hours sheet to rotate the names and hours associated with the names automatically when the data in those cells is changed/updated. I would like the list to sort so that the person with the lowest number of hours is on top. I am almost there but I just can't figure out how to get the name cells to match up to the hours cells once they have been sorted. Any help would be appreciated. I have attached what I have so far, I would like the names to show up in column I in association with their hours count in column J. Thanks in advance for any help.
Sean

Hi and welcome to the forum

I have made some modifications to your file, see if you can work with them. Instead of 1 sheet/EE, I created a Data sheet - you enter all date in here. Then I created a nee Summary sheet, and pulled in all unique names, added up their hours - and added a tie-break, just in case (yellow table). You can hide this if you want, it is just to get the data.

Then I created your summary table, ranked low to high, with the names

Im happy you got the answer you wanted

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

First of all, welcome to the forum.

This thread is approximately 3 years old. Adding on to a thread with a problem of your own is called hijacking and is against the forum rules. You should start a new thread of your own describing the exact problem that you want to solve. Include an Excel workbook that has enough data to show the problem and a mock-up of what you envision as the solution.
Directions to upload a workbook:
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Did you figure how to make the hours go from low to high?