Detailed sorting

Hello,

I have a somewhat complicated task that I'm hoping a macro can help with.

I have a spreadsheet that I receive regularly. I would like the macro to sort column J into tabs at the bottom of the sheet (there is a header that reads "Parts" in this column).

Then, within the tabs, I would like the macro to put the data into another order using column C (there are numbers in this column, and I would like to sort these specifically, such as 1, 4, 5, 9 etc.).

Is this possible to do?

Thanks!

J