Macro copying number to the wrong column. Can you help me fix it?

Hi,
I was wondering if someone can help me.
At the moment the most of the macros on this spreadsheet are working fine.
However, when I filter the Revenue Report tab (yellow tab) by confirmed, and then go to the black tab (invoice audit) and press the copy from yellow tab button, it copies most of the data correctly.
However there is something its doing incorrectly.
One of the columns thats copying over, is copying it incorrectly. Here's what it should do...
I need that whatever is in column J on the yellow tab (Revenue Report), to copy to column I on the black tab (invoice audit).
Can you please help?
Thank you in advance.
Cele

There's good news and bad news.
The good news is it copied the number on the right column.
The bad news is, it then duplicated it again, and caused to shift data one column to the right.