Data Population

I am trying to write a macros that will take data from a worksheet and transfer it to another under the corresponding cells. The MIDAS DATA worksheet contains data in rows BB3:BR20 that I want to transfer to the corresponding data cells in the DATA worksheet. The MIDAS DATA worksheet is continuously updated from a survey, the idea is for the data from MIDAS DATA to populate the DATA worksheet, however there will be multiple rows in MIDAS DATA that will have the same date and unit and so this data has to be summed and entered into the corresponding unit and date in the DATA worksheet so that it acts like a living document that is updated as soon as MIDAS DATA is updated. I am doing this because my pivot charts are based off the DATA worksheet as I can't build a pivot chart that accurately displays the data from the MIDAS DATA worksheet because the pivot table will not add together the sample sizes (the TOTALS column). I have attached my file for clarification.