I was going to use the auto filter, however I only want the results for the students to appear when the different test is selected in the cell C11 instead of changing the filter every time.

This is a small selection of information from a much greater spreadsheet and the data would normally be on a hidden sheet so the results will be in a new sheet.

Thanks