Transferring data from a price list to a bill of materials

Hi there,

So I have a price list with a list of products and costs, sorted into type of product, I also have a bill of materials worksheet. I want to be able to enter a quantity on a product in the price list and automatically have that product info move into the bill of materials sheet. I don't want the product to show up in the exact same row on the BOM page though, I want it to show up in the first available cell, or a selected range of cells.

I don't know if this is possible, or how complicated it would be.

Thank you for your help!!

Here is the spreadsheet I'm working with:

SES Grid Tie DC Power Worksheet 10-24-08.xls