How do you move a number field data point from several tables to a master table field.

Ie. example 1. Price field from several vendor tables to one Price field in the master Inventory field table

Also, all are connected thru a separate key field.   Sku field