Add number of occurrences from one sheet and place on another

I am a fairly new user to Excel.
I generally only use a couple of workbooks daily,and have made only basic spreadsheets for my own use.

I need help figuring out what to do with one, or even if what I would like to do is even possible.

I have a sheet I use to order Engineered lumber I call it my "builder" sheet. I order engineered lumber by rail car, I use this sheet to build the car.
This sheet helps me track what material is on the car.
The rail cars have two sides.
I have 11 different types of material i'm ordering, in 21 different lengths.
A car will be a mixture of any number of combinations of type and length. The material has different heights as well. The material weight is calculated per foot as well.
I have to have a certain length (72') and a certain height (133") on each side of a car.
I also have target weight I'm trying to reach.

I have two pieces of information I use on this sheet:

Item code
Length

As I have it designed now, I have a cell for the item code, and a separate cell for the length. I enter the code and the length. My sheet then registers the length, height and weight of that pack of material.

I have a separate form that I send to my vendor to actually order the material. This form calculates the weight and is just a count of how many packs of each size and type of material I'm ordering.

There are always errors in transferring the information by hand from one form to another.

I was wanting to create a sheet that would track the information I am inputting on the "builder" sheet and transfer it to the "order" sheet.
I have created a "formula" sheet that will do this, but to cover all of the possible combinations of material type and length I will have to enter over 50,000 individual formulas.

I'm hoping there is an easier way. I'm not even sure Excel would be able to process that many calculations.

I can post my work so far if necessary.

Thanks.

Rule 1

http://www.excelforum.com/forum-rule...rum-rules.html

Change it before a mod comes along