I have a worklist with calculations on one tab and a table that has
four columns and is about 100 row long. 1st, I would like to create a
worksheet that I can use to enter data without accessing the
calculations, where the input data would be entered and the output
displayed. I can do that with links between the worksheets.

I can't figure out the second part. I have 100 machines on a list,
each with size, weight, and height. How do I make a pick list, or
drop down menu to choose the name of a machine, so that I can display
the machine type on the input form and be able to populate certain
fields in the calculation with height, weight, and height, e.g. if
HP100 was picked from the list, the height would go to cell B15, the
weight to B22, and the height to B55?