Work schedule/ multiple outputs from one search criteria

Can you work with this?

On Sheet1 use Columns F:G as helpers
In F11

Please Login or Register  to view this content.

In G11 This array formula

Please Login or Register  to view this content.

Enter with Ctrl+Shift+Enter not just enter
Drag/Fill both Down.

On Sheet2
In D1 Put a drop-down validation list using the dynamic named range "Names", add to it as required, just keep it continuous, i.e. no blanks.

In E1 This array formula
=MAX(IF(Sheet1!C11:C115=D1,Sheet1!F11:F115,""))
Enter with Ctrl+Shift+Enter not just enter
In A4 This array formula

Please Login or Register  to view this content.

Enter with Ctrl+Shift+Enter not just enter
Drag Across to Column E, then down to say Row 50

Columns C:D can be hidden. {I've used grouping buttons.)

Select from the drop-down in D2 to see the results change.

Hope this helps