Returning Information Via drop down?

Hi Guys,

I need some help with a spreadsheet I am using. On this spreadsheet I have all colleagues hours that they are working.

I want to be able to print this spreadsheet out individually to give everyone a copy of their hours specifically.

I was thinking of creating a new sheet and I want to have a drop down menu with their first name, when I select their name from a drop down their hours appear. Whilst this spreadsheet is currently horizontally I’d probably want their hours to be week by week in a vertical format.

I’m unsure of what formula or function I use? Would it be a vlookup? Unsure of how to process sounds simply in my head ‘select a colleague and it returns all their hours then I can create a macro to print, any ideas?