Microsoft Office Professional Plus Excel Spreadsheet data transfer?

I want to begin by saying thank you for taking the time to read this.

Okay, I am in charge of creating a series of Excel worksheets for a company. I have an idea on how to make it but I am curious if there may be an “easier” way or maybe a more efficient way.
Okay, I currently have 3 separate spread sheet files, one will be for parts, one will be for technicians, and the third one will keep track of parts numbers and link them to specific asset numbers. I want to make these spreadsheets “linkable” in the sense to where when one specific cell is updated in any of the 3 Excel files, it will populate the specific data entered in the correct columns in the other worksheets.

For example. If a technician submits an asset number and a part needed for a repair, it will auto populate in the “Parts” spread sheet with the part the technician is looking for and the part number. BUT if there is no associated part number for that “part” I would like to set it up in a manner that when Parts manually inputs the Part number into their spread sheet, it auto populates to the 3rd Worksheet that links a part number to the asset number and the “title” of the part.
So basically there are 2 worksheet files that get manually manipulated, and the 3rd file compiles the data from those two files and “links” key words to the for the other Parts and Technician worksheet.

Technician Worksheet:
1336 (<–asset number) | Pick scene conveyor making loud clunking noises (<–Issue) | Parts requested _______ (<–part needed by title)

• Now not all this data gets transferred to parts *

Parts Worksheet:
1336 (<–asset number) | Part by “title” | Part Number associated with asset number and “title” | # of parts in stock | issued/returned |

“Stock” Worksheet:
Asset Number | Part Number | QTY Parts in stock | QTY Parts when to Order |

This is a very basic rough draft of what I am envisioning.

But essentially my goals are:

1. make it easy for a technician to insert a part they need to make a repair without wasting time to find out if parts are in stock or what the part number is. Also allowing the technician to know if parts are in stock or not (and if not if they have been ordered or not)
2. Allows for a means to track QTY of parts in stock for the Parts department and Auto-fills a “Part Row” Green/Yellow/Red for when to order parts
3. Creates a compiled database for parts in the warehouse that are used so that way there is no struggle in ordering the wrong part as well as tracking Parts in the department stock.