Full Down List That Filters
 

I need to present a workbook to a group of non excel users to fill out
various information for their corresponding name. I need to do this in a way
other than using autofilter. I was looking around for some way that when the
user opens the workbook they can choose their name from a pull down list and
choose their name therefore displaying only their corresponding data. For
example, Kevin opens up the file and chooses his name from a pull down and it
displays only his 10 entries from a list of many other names. Could someone
send me in the right direction for this? Autofilter is not an option. Thanks