merging data to a form

I have a spreadsheet with a couple of thousand options (handrail parts) that I want to be able to select quantities of, and have them incorporated into another spreadsheet that will calculate the labor fees associated with these parts, all printable on an existing form. I would need 4 cells (product, model, size & qty to copy to the 'master sheet' without creating a form that is 200 lines long. How do I do this?

I'd also like to be able to use drop down menus to link to the specific page in the workbook, can I?