Ive Explained what i am looking for in the attached Excel sheet. if anyone can help me figure this one out that would be great.

Thanks,


Consolidating Workbook.xls