I'm struggling to make a sheet work as I intend. I have various sheets in a file where the first one is like a database of quite a few components and the other sheets are groups of components that create a product we sell. See example attached.
The thing I want to do is if I fill a cell in the product sheet, in this case would be "internal description", the other cells are filled automatically. That way, I think, if I change something in the database it will be automatically changed in the product sheet (price, ref,...), right?