Multiple tables same data and edits

[Dxm31]

I have a table that is being added to with results of a online form via a power flow adding the results to the table in excel. Their are hundreds of entry’s being added everyday. I need to be able to create separate tables on separate workbooks to try and make it easier for supervisors to view and edit results. How can I copy a row from one table to another if a condition is met and further more how can I have the data transferred to both tables if a change is made on either of them.