Update multiple tables from a value of one table

[Neeraj_Malik]

Looking for solution on how I can update the values in multiple tables from the value of one (source) table. This is to deal with following sceraio

There are 4 tables

Buyer_PO
Exporter_PO
Importer_PO
Customer_PO

Key to all these tables are common with column name Purchase_Ref. All these tables also has another common column named as Shipping_Status

Adding a row to Buyer_PO adds rows to all other other tables with same key and shipping status

Now I want to create an Action/Bot that if the Value of Shipping_Status is changed, then a Bot/Action should update the value of Shipping_Status in all the tables.

Any suggestion to help me out pls @Steve @Marc_Dillon @WillowMobileSys @Suvrutt_Gurjar 

Thanks in advance.