I work in construction estimation and am often plugging in the same data
repeated times. Is there any way to create a workbook or sheet for example
with a control material list with prices and other data in different columns
and then access and insert this information in different workbooks with a
pull down menu or some other method? Example: A workbook would have material
list of 2 X 4 lumber of varying lengths, and prices attached to each piece.
Then, when doing estimates if I need 2 X 4 X 10, I would type this in a cell,
or choose it from a pull down menu and the price and other data would
automatically be entered in adjacent cells.

It would make data entry easier, and if I have to do material price changes
I can do it once in the control workbook instead of a bunch of time
throughout the estimate.