Update automatically tables with related headers that are in different sheets

Hello to all in forum,

Advise of you experts please in a way of how to do this. Is like to have a kind of relational databases within Excel, even I know
that Excel is not MS Access.

I have a database table with products info in Sheet "Products", this is the master sheet. And I have one sheet for each type of product,
that contains a database table with the data from sheet "Products" but only for determined product.

The issue is that I need to add, erase or change info in main sheet, and I need that change be updated in
each product sheet and viceversa. For example,

- If in the main sheet "Products", I add/erase/change info for product 123 in columns A-F, I want that change be updated automatically in sheet named "Product123".
- If in the sheet named "Product456", I add/erase/change info for product 456, I want that change be updated automatically in main sheet "Products".

Erase could be, remove a cell content or remove the complete row. So in the corresponding sheet should be the deleted too.

I hope you can help me saying me how good be a good or easier way to do this.

Thanks in advance for any help.