Macro to copy data from one sheet to another depending on name in first cell

Hi All,

I am having troubles getting a Macro to work with the sheet I have attached.

Basically I need it to loop down the 'Data Analysis' sheet and for each Component in Column A (1-10), copy the line and then paste it for this month on the sheet 'UK' in the row marked as the same Component number.

The attachment should make it clearer.

I hope that makes sense.

Thanks in advance!
James