Help with creating a macro that will copy and paste data to multiple sheets.

Hi AB,

Thanks for taking a look at it for me. I have made the changes you suggested above however there is still an error code apprearing even though It is coping more of the data and into the correct place. It does seem to be just copying a couple of columns aswell not the whole row.

My brain is fried from this, would you be able to take a look for me and see if theres anything that need to be changed?

Than you so much

Adam