Copy data from a sheet based on entered product code

Hello all,

Hopefully someone can point me in the right direction or let me know if this is even possible without being overly complicated. I've tried implementing vlookup functions, VBA code that copies and pastes data based on a column and row input, but none work anywhere near where I want them. I don't have a lot of VBA coding experience, and only a good understanding of excel functions.

I have an excel spreadsheet that we enter a product order code. Each part of the code represents a certain "option" that, if selected, adds required parts to the order. What I'm trying to accomplish is to take the master data from one spreadsheet and put it in another spreadsheet that only has the required parts to it.

Example time...

Sheet 1 has the following table in it.

A1

B1

C1

D1

E1

F1

G1

H1

I1

J1

Each column represent a different "option" and some columns can have more than one option assigned to it. Meaning column 1 can have either option A1 or A2 in it, and subsequently for the remaining columns.

Now Sheet 2 has a "master list" of every option set up as such:

Qty1	Description1	Manufacturer1	Option-Code1 (A1)
Qty2	Description2	Manufacturer2	Option-Code1 (A2)
Qty3	Description3	Manufacturer3	Option-Code1 (A2)

And the list continues for about 200 rows. As stated previously, each part "option" can have multiple items assigned to it.

So in the end, what I'd like is to pull only the records that match the options and put that compiled data on Sheet 3.

Also, some of the options utilize the same parts. It's not important, and not even required,but is there a way to consolidate the items that repeat and update the required part quantities to total?

Thanks in advance for any help or suggestions!

My apologies.

Find attached an example spreadsheet that has sheets populated with some data. The last sheet is what I want to see happen based on the criteria laid out in post 1.