Data lookup formulas

[sv29]

I was hoping someone could help me with a problem I am currently working on:



I have 2 different data sets which are dumped into 2 separate tabs in excel, 1 of the date set is all the costs i have on a project and will be updated monthly by simply adding the previous months costs to the bottom next available rows (not doing a complete data dump). The second tab will be a data dump breaking down the PAYROLL costs into each person, again this data will be updated monthly, however this can be a complete redump of all the months data if need be.

Please see attached example, my goal is to have the PAYROLL data in the Cost Dump tab to breakdown and show all the detail of these costs on the same tab and produce a result as per the Expected Tab. The Cost Dump tab will essentially be the master tab as i will be also added comments/notes against the other costs (ex Rental, Lease, consultant, etc.), so i don't want that information lost every time i do a dump. My vision would be that every month i would add the additional lines of costs to the Cost Dump tab and then as i update the Labour Dump tab, the Cost Dump tab would just add in the additional rows and populate the columns D-H automatically.

Could someone please help with a formula or macro to do this?

Thanks