Extract (only non blank cell + highest value) data from multiple tabs

Hi guys...Please help me with my workbook (attached)

In the workbook there are four tabs i.e. Cumulative, Data1, Data2, Data3. Tabs Data1, Data2, and Data3 contain information of student performance in each semester.

My question is: how to extract automatically informations from Data1, Data2, and Data3 and put it all on Cumulative with these two additional conditions:

• I only want to extract all non BLANK cell of B5:C9 from each Data1, Data2, and Data3
• If there are subject that retaken, I want to extract data with the highest grade. (as you can see in Data1, Data2, and Data3 there is one subject that always appeared i.e. BIO1201, this subject was retaken twice with highest grade is B).

I am sorry for my bad english, i hope you can understand my question. Thank you so much!

Here is my take on it. I am a believer of making the spreadsheet do as much the work as it can and use VB only to tie things together and to clean things up.

This spreadsheet works by copying in all the data from each semester. It then deletes those rows where the grade point is not the maximum for the course and then goes back and deletes any duplicates.

I changed the data range on the Cumulative Sheet to an Excel Table. Excel Tables duplicate formulas down automatically and I use this feature. I also added helper columns to do calculations rather than try to do them in the code.

The helper columns are:
Grade Point - this is a VLOOKUP from the Grade / Grade Point table to get a numeric value for the letter grade.
Max - this is an array formula: =MAX(IF([@Code]=[Code],[Grade Point],FALSE))- it gets the maximum grade point for a subject.
Keep has the formula: =[@[Grade Point]]=[@Max] - this is true if the score on that row is the maximum.
Duplicate has the formula: =MATCH([@Code],[Code],0)=ROW()-4 - this is true for the first occurrence of a Course Code.

These helper columns may be hidden so the sheet looks like the original.