Value Lookup

Hey, I've been asked by my boss to create a more efficient "attendance sheet" and I'm having some problems

I'm looking for a function to look up a value from other worksheets after selecting a person's name from a drop down list. Here is an attachment to further illustrate what I'm looking for

If someone could help me out here, I'd really appreciate it

Thank you for your time,
Bob