What problem is solved for you by duplicating the same data into two tables?
What problem is solved for you by separating the "active" and "inactive" data into different tables?
Does your Table A have an auto-entered primary key field that uniquely identifies each record?
If so, you can link tables B and C to Table A by this field in relationships. You could then use OnRecordCommit to perform a script that checks the value of the status field and uses either two different blocks of Set Field steps or one block of Set Field by Name steps to copy this data to a related record in B or C.
But I am curious as to why you want to do this in the first place.