How to automatically extract data in this case

I am working on a workbook that automatically extracts the list of students that are failed after every shool year. The details are in the file attached. To be clear, the sheet named "Failed" will automatically scan the information of every student in the sheet named "Data", and then extract, fill the detailed information (Name, Class, School, Attendance, Attitude, Reading Mark, Writing Mark, Speaking Mark) of the students that are failed.

I don't know if the Excel fomulea could do that or have to use VBA to solve that problem. I don't know VBA so I prefer to use of formulea.

Could any one help me?

Thanks.