Auto Input

Hello,
I was wondering if it is possible to auto input data from "sheet2" to "sheet1" when I type in the number of the "wanted" row.

For example: I have a sheet filled with formulas for bidding work. I enter data into each separate cell right now and the formulas calculate the "sum." I was wondering if it is possible to use "sheet2" as a database and fill in all those cells and formulas, then when I want to select a particular "product/cell" all I have to type into "sheet1" is the corresponding row, or even better make it be related to "column C."

Better Example: SHEET2= database
Sheet2 ~ material = BL8, cost = 1.15, multiplier = 1.125
~~~~~~~material, cost, multiplier = separate columns.
Then what I want to do is in "sheet1" be able to type:
sheet1 ~ type in ~ material = BL8,
~ then have the cost column and the multiplier column auto fill.

I dont know if I can use a separate formula or if I need a MACRO. I do not have the knowledge to come up with my own MACRO.

Right now I am taking up columns A-R.

Sorry if this is already answered in another thread. Could not find it myself.
Thank you in advance for any help.