Linking And Finding Information

I have a spreadsheet with roughly 20 or so tabs. Each tab contains about 20-50 components which together form a product, so each tab is really a detailed list of what the specific product contains.

One component occupies one line, just a few cells, where you can find basic information like "name" and "price" and other things, but name and price are what's interesting in my case.

What I have done is taken each unique component and placed it on a first tab, creating a list of every unique component with full information on it. I then wish to link that information to the correct component in each tab, so that when you change somethin, for instance purchase price, on the first tab it changes for all the components of that type through all 20 product tabs. Now I know how to do this manually, but it's a lot of work to do that with every component in the document.

so my question is, is there a formula or way for me to make it easier? For instance, perhaps let excel search for the same component name in the database sheet and link the price automatically to that component in the product tabs? I don't know, I just figured there must be some easier way to link the information then me hopping back and forth between tabs 'till my hair turns grey.