Copy/paste cell A to new sheet if cell B=1or2

Hello everybody,

I am slowly trying to learn about Macros to make my data sorting and report running easier and am asking for some help/guidance from the pros. I have a report that generates out of ART and exports to an Excel worksheet and I would like to have a Macro that will copy and paste the data from columns C, D and J in a given row only if the value in column J in that row equals 1, 2 or 3. If the value is not 1, 2 or 3 it will be blank or zero. For example, row 3 contains value in column C, value in column D and a value of 2 in column J, I would like for the macro to copy and paste each of those three cells onto a new sheet in columns A, B and C with a row 1 of those columns having a title (e.g. Column 1) in each of the top cells. I would like for the macro to continue searching the length of column J looking for values 1, 2 or 3 and then end after it has moved all data from each row with those value in column J onto the new sheet. If this even possible? And thanks for taking the time to read through my probably very comfusing explanation!!