Displaying Data sets

Hi,

Not even sure what to call this question or if it even possible.

I have a spreadsheet that lists users plus 4 columns of data horizontally and other data vertically. See image forum_sheet.png

My problem is the sheet is getting wider and wider as users are added. What I would like to be able to do is have a dropdown or something that allows me to select a users name which would then display their data set [ four columns ] on its own. I have tried validating a dropdown list but this only works on a single column. See image forum_sheet_2.png

Any help appreciated

Roger

can you please upload a sample workbook