Table Updates between worksheets

Lpic - Feb 26, 2016 at 08:50 AM

I have 3 worksheets, each with a range formatted as tables. All the tables have 2 columns in common 'ID' and 'Vendor'. When I add a new ID to the table on worksheet 1, I want the ID and Vendor inserted to the other 2 tables/worksheets. Essentially ID is my primary key and I want to link the three tables based upon ID. When I insert a new primary key to table 1 I want the other 2 tables to receive an insert of that new key. Is it possible or do I need to change the structure of my tables/worksheets?

Thanks for your help!