Organizing data by time on a different sheet

I'm having a hard time wrapping my brain around how to title this so here is what i'm looking for; I'm a golf professional looking to put together a starting-time tee sheet spreadsheet for a tournament xls. What i am looking for this to do is have the ability to input a name and a desired time, ie:
sheet1
(column a) (column b) (column c)
Player Tee Time Starting Tee
Joe Smith 8:40 1
Mark Smith 8:50 10
Ryan Smith 8:40 1

When the data is inputed this information would then appear on another sheet. They layout should be:
sheet2
(column a) (column b) (column c) (column d) (column e)
Tee Time Player 1 Player 2 Player 3 Player 4
8:30
1Tee
10Tee
8:40
1Tee Joe Smith Ryan Smith
10Tee
8:50
1Tee
10Tee Mark Smith

I'm struggling to find a way with out having a silly long formula that tests each cell for the criteria. I considered making each tee time have a hidden number associated with it (ie 840, 1t = 1; 840, 10t = 2). I'm also struggling with how to see if column 1 is full to put the player in column b. If anyone can point me in the right direction or help out in any way it would be much appreciated.

Thanks!

Hi Keener
I like golf, so I've written some very basic code behind your sheets. See the attached example and how I've layed out the sheets. Read the code and change it if you need to fit your own new sheets.

Good luck.

MarvinP,

This is right along the lines of what I am looking forward. Thank you! I am not the best with macros so pardon my ignorance; I have attached a second file that is the actual workbook that I've started with. If you wouldn't mind explaining how I can either add more buttons to calculate tee sheets for the other tabs. In the end i have 4 tee sheets (two courses, two days). There are a few things, on the first tab you can see there are very basic formulas that we can easily adjust the starting times and the tee time interval. The tee sheet is fine the way you made it, but if i wanted to edit the layout would i need to edit the macro? Say if i wanted to lay it out like the attached Tournament Software xls, would that be easily done without messing up the macro?

Thanks again for your help.