generate a summary list of names extracted from different worksheets given a condition

Good day everyone,
I need help on this one. I am tasked to generate a list of names in a separate worksheet taken from different worksheets satisfying one condition. Example make a list of students who scored below 7. I am attaching the file to give you an idea how the report should be generated. thank you

Hi welcome to the forum, i see the file, dont understand the requirement, you say student that have score below 7, but the data is all above 7 ?

Thanks

thanks for the reply. what i mean is students who get a grade below 75 NOT 7. sorry. what i want to happen, in another sheet it generates a list of all the names of students who get a grade below 75

see the attached file

I combine results in one table, have take a look the file attach

Thanks