Help with modifying code to copy specific cells on target row instead of the whole row

Hi,
I am currently using the following code obtained from here to copy a target row from one workbook to another. The sheet I am copying from has coloured cells, conditional formatting and 2 objects (buttons) on each row. The code works just fine, but I would like to know if it would be possible to modify it so that it only copies specific cells on the row instead of the whole row and removes the formatting so that all it copies across are the cell values.
The code I am currently using is as follows.

Please Login or Register  to view this content.

Thanks in advance

Replace this...

Please Login or Register  to view this content.

With something like this (change to suit)...

Please Login or Register  to view this content.

Thank you very much, it worked perfectly and is greatly appreciated.