Need a macro for transferring data based on unit value to corresponding tab

I get data that will give me a list of units and data in the next two columns. I need to place this data in the corresponding tabs of the report that is already created. The data is kept track of each week so each time it is pasted in the tabs it will need to be pasted at the bottom of the data. Also the naming convention for the units on the data and the report will not always line up which I demonstrated in the examples. Attached are simple examples of what I am working with. Please feel free to ask any questions.

hi doubl3d80, please check attachment, the code is assigned to a button in report.xls