there are ways to do that:
one of them could be using Trigger like the following
CREATE TRIGGER tbl1_after_insertT ON tbl1 AFTER insert as
BEGIN
INSERT into tbl2(id, CODE, NAME)
select id,CODE,NAME FROM
INSERTED
END
another one could be using replication, in your case if the tables are being created dynamically, it is very hard to set it up. but it's still an option