Cross Reference of two tables to create a third

[lucidus]

If someone could please help:

I have the following two sheets:

Sheet 1</SPAN>						Sheet 2</SPAN>
	Inventory Required</SPAN>	Item1</SPAN>	Item 2</SPAN>	Item 3</SPAN>			Inventory Required</SPAN>	Item1</SPAN>	Item 2</SPAN>	Item 3</SPAN>
Product</SPAN>						Supplier</SPAN>
P1</SPAN>		X</SPAN>				S1</SPAN>		X</SPAN>
P2</SPAN>			X</SPAN>			S2</SPAN>		X</SPAN>	X</SPAN>
P3</SPAN>				X</SPAN>		S3</SPAN>			X</SPAN>
P4</SPAN>		X</SPAN>	X</SPAN>	X</SPAN>		S4</SPAN>			X</SPAN>	X</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL><COL span=5><COL><COL span=3></COLGROUP>

I want to create a Sheet 3 that automatically cross references the above sheets as such:
If a Product (i.e. P1) maps to an Inventory Required (i.e. Item 1) and an Inventory Required (i.e. Item 1) is mapped to a Supplier (i.e. S1 & S2) then the results would show which Product (i.e. P1) requires which Supplier (i.e. S1 & S2). It doesn't necessarily have to look like the graph below, a list will do as well, but it would have to be a sustainable/automated process seeing as how there are 200 Products/Supplies and 400 items that constantly change and are "re-mapped." Thanks for your help!

Sheet 3</SPAN>
	Suppliers</SPAN>	S1</SPAN>	S2</SPAN>	S3</SPAN>	S4</SPAN>
Product</SPAN>
P1</SPAN>		X</SPAN>	X</SPAN>
P2</SPAN>			X</SPAN>	X</SPAN>	X</SPAN>
P3</SPAN>					X</SPAN>
P4</SPAN>		X</SPAN>	X</SPAN>	X</SPAN>	X</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL><COL span=4></COLGROUP>

 

[akmatz]

Will the tabbed sheets always be named "Sheet1", "Sheet2", "Sheet3"?

 

[lucidus]

The names of the Sheets will not change.