Transposing Info or Pivot Table???

Evening,

I'm not sure of the name/technique I am after, but essentially it is where you have a drop down arrow and you can select a name and then it shows only the data that relates to this.

So in my case the first sheet has all the data for a whole class of students (the values are 1,2 or 3, and this then conditional formats the colour of the cell).
On the second sheet I would like to have the 'arrow box' in cell B1. You select the student name in it and it drags all the info for just that student and it puts it in the sheet.

Any help you can give would be great.

Thanks