Group sort candidates

Hi

I have a list of candidates with some data which I need to sort into 4 groups using VBA. The number of candidates can change so the group tab needs to be able to "extend" itself.

The candidate data (tab 2) itself is displayed in 2 parts (Columns B to D and Columns H to J). Ideally, once grouped, I need to distinguish between these 2 sets of groups. At the moment I have just used two colours (Orange Group and Blue Group).

I have attached my DUMMY DATA sheet and on the first tab I have shown part of how the end result should look like.

Can anyone help?

Many thanks in advance.