"Name" list could be done using Data Validation and cell population using
VLOOKUP (or INDEX/MATCH).

Need further details to give a more precise answer.

"Sarah" wrote:

I am looking to start having my department do our timecards electronically.
What I would like to know is if there is any way to do the follow:

When the employee opens up the template they are able to go the the "Name"
field and choose their name from a list - than when they choose their name
other fields are populated automatically, such as manager, employee ID....

is this possible?