Excel 2007 : Matching and combining data out of 3 columns

Hi fellow Excel users,

I have a small obstacle I can't get over.

In attachment you'll find a Excel workbook with two different layouts. The first area marked in red is the data I currently have. What I need the script to do is to copy everything in into column E but changing the matching and combining the data like you see in the green area. In the second sheet you'll find the code as I have it now, but somehow it mixes up the data.

Can you guys help me out?

Thanks in advance for all your help.

Greetz,
Tino XXL