SQL to insert a row on the table should insert into another table

SQL to insert a row on the table should insert into another table

I have a insert query on table A, it should insert to another table B.
This insert should not happen to table A. Do we have any trigger to
transfer this insert query on other table B instead of table A?
Any suggestions?