Table1 feeds Table2 automatically - possible?

[RickFreeson]

I have a situation that I cannot find an answer to no matter how hard I search. So I am turning to you good people.

I have data that is appended as new rows to a table. Because of other technicalities, this data comes in jumbled and out of order.

Is it possible to have this table automatically update another table where I have the layout the way I need for the rest of the workbook to work?


Data in:
Table1
Cat1 Cat2 Cat3 Cat4 (Header)
abc cbd hij lmn (data)

Copied to the correct places in table2 automatically:
Table2
Cat1 Cat1a Cat1b Cat2 Cat3 Cat3a Cat3b Cat4 (Header)
abc 123 456 cbd hij 789 123 lmn (data)

Can a table feed another table on a different worksheet?

Thanks in advance.

Rick