Lookup columns with several same names

I have a column of some 100 names which are often duplicated with 12 cells to the right containing numbers on one sheet.

In another sheet I want to type one of those names and have Excel look up that person from the sheet where he is mentioned several times and have those rows 12 cells replicated one after the other starting on the same row as the name and the rest underneath. Thanks for any help, Paul P.