populating production sheets

[cocciaaccounting]

Hello everybody.

I currently work at a company that produces whey protein products. For are first few years operating we have been using excel forms to produce are formulas and production sheets, but each time we do a new job, we have to manually enter in all of the information for each job like part numbers and description etc... We use a Inventory database that creates a Bill of Materials for each job based off of 1 unit of that job which may have 12 different ingrediens in it.... I guess what I am getting at is that we would like to be able to export a BOM out of the database and into an excel worksheet and then from there populate are sheets based off of that BOM by only having to click on a dropdown box which contains all of the job #'s. Were very good at using excel for what we currently do but are knowledge beyond that concerning pivot tables, controls VBA code etc... is not great. Here is are production sheet which we would like to be able to populate. Sorry if this makes no sense, its a very tough industry to try to explain but any input would be greatly appreciated.

Customer:

<tbody>
</tbody>

Customer:		Lot #:
						Blend Sample#:
Salesman:		Production Date:
Product Code:
Product Name:		Blend Size:
Formulated by;	Paul
Revision:
		Fill Wt:				Stamp Data	Line1:	Lot#	Line2:	Mfr Date
PART#		Description
	Container
	Lid
	Lid2
	Scoop (Y/N)
	Box Size		Qty/Box:
	ShrinkBand (Y/N)
	Label (Y/N)
Label	Ingredients	Total per batch	Weighed	Mixed	Lot#
kg	gm	lbs	By	By	By	By
						0.0000
Blending Time 20 mins	Blender #
Start					Scale Weights Verfied By: ______________________________
Stop		Scale #
Date					Notes/Adjustments to Blend (if any): ______________________

<colgroup><col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;"> <col width="36" style="width: 27pt; mso-width-source: userset; mso-width-alt: 1316;"> <col width="17" style="width: 13pt; mso-width-source: userset; mso-width-alt: 621;"> <col width="105" style="width: 79pt; mso-width-source: userset; mso-width-alt: 3840;"> <col width="66" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2413;"> <col width="65" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2377;"> <col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;"> <col width="64" style="width: 48pt;" span="2"> <col width="58" style="width: 44pt; mso-width-source: userset; mso-width-alt: 2121;"> <col width="57" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;"> <col width="29" style="width: 22pt; mso-width-source: userset; mso-width-alt: 1060;"> <tbody> </tbody>