Attendance Analysis

Dear all

Is there any excel expert out there.
I really need your expertise.

I have an excel sheet which contain Student names, class, student attendance and their attendance percentage.

I will need to further develop the worksheet into a new worksheet where by it will pull out the names and class of those students who had obtain less than 50% from sheet 1 and 2.

Eg:
Stephanie (From sheet 1), May and June (From Sheet 2) have attendance less than 50%.
All 3 of them are from the same class.
How do I pull of their names and put into a new sheet lets say sheet 3

Do get back to me regarding my queries.

Your help is strongly appreciated.

Thanks