Macro to find data in source workbook and copy paste to target workbook

It was not my intention to merge cells, I have checked though and am pretty sure there are none but it does have various formulas and conditional formatting already in place if that matters, it was created as a template to manually paste this data onto.

This script does now retain the bottom section of the 2014 sheet as I described. It still doesn't paste the data correctly onto the 2014 sheet.

There is something else I realised I haven't mentioned yet. Ideally this needs to consider what is the current month, and copy the 2014 figures upto the current month, but not including the current month, and for this to work correctly at whatever time of the year it is used. Is that possible?

I have attached a further example that shows what it ideally should look like after running the macro, this is assuming it is used now with regards to the point I have made above.

When doing this, I pasted the values only onto the template, maybe that is important as well.