Drop downs & Autofills

Hey everyone,

I am new here and have a question. Bare with me though because I am not sure if my explanation is going to be clear.
Attached is the sheet I am currently working on.
There are multiple sheets with lists with multiple columns.
The first sheet, the setup sheet, is where the user is to input data.
I want to be able to input a part no. and have the rest of the fields either input the correct data, or create a drop down to select from (if the part is in multiple machine lists). From here, i would like all of the information to fill in properly from there.
I have yet to use macros myself, but i feel like this is able to be done.

Any help would be appreciated.

Thank you!

Fred