Information transfer

Hello,

I am trying to create a way for me to type in a part number as a list for tracking inventory and have the information (parts, description, transmission group, transmission type) be filled in from the specific transmission parts lists that are located in sheets that follow after the main inventory list. The main inventory list has part number, part description, quantity, location, other/notes, transmission group, then each transmission type listed to follow after that. Listing the transmission type is to only show the specific transmission(s) that the part(s) can go into. The sheets to follow are lists from our parts break-down books for each transmission to show the required parts for each transmission type. My hope was to be able to type in part/parts numbers into the ‘main inventory’ sheet and the information that is pre-filled in from the book sheet (i.e. part description, transmission group, etc) to be filled into the ‘main inventory’ sheet. Also, if possible that when I put in a quantity for how many of each part that I have on hand in the ‘main inventory’ sheet for that amount to show up in the individual transmission parts lists to see if/when/how many transmissions we can make out of the inventory on hand.