Ticket tracking

I need help building an excel sheet for ticket tracing for our fire department gun bash. each ticket has 5 numbers on it that are 4 digits long. id like to be able to enter a name, and the number and it assign it in numerical order in a spread sheet with their name in the column beside it.