Cross Reference of two tables to create a third

[lucidus]

If someone could please help:

I have the following two sheets:

[TABLE="width: 835"]
<TBODY>[TR]
[TD]Sheet 1</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Sheet 2</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Inventory Required</SPAN>[/TD]
[TD]Item1</SPAN>[/TD]
[TD]Item 2</SPAN>[/TD]
[TD]Item 3</SPAN>[/TD]
[TD][/TD]
[TD] [/TD]
[TD]Inventory Required</SPAN>[/TD]
[TD]Item1</SPAN>[/TD]
[TD]Item 2</SPAN>[/TD]
[TD]Item 3</SPAN>[/TD]
[/TR]
[TR]
[TD]Product</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]Supplier</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]P1</SPAN>[/TD]
[TD] [/TD]
[TD]X</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD]S1</SPAN>[/TD]
[TD] [/TD]
[TD]X</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]P2</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X</SPAN>[/TD]
[TD] [/TD]
[TD][/TD]
[TD]S2</SPAN>[/TD]
[TD] [/TD]
[TD]X</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]P3</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X</SPAN>[/TD]
[TD][/TD]
[TD]S3</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X</SPAN>[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]P4</SPAN>[/TD]
[TD] [/TD]
[TD]X</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD][/TD]
[TD]S4</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL span=5><COL><COL span=3></COLGROUP>[/TABLE]
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!

[TABLE="width: 393"]
<TBODY>[TR]
[TD]Sheet 3</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Suppliers</SPAN>[/TD]
[TD]S1</SPAN>[/TD]
[TD]S2</SPAN>[/TD]
[TD]S3</SPAN>[/TD]
[TD]S4</SPAN>[/TD]
[/TR]
[TR]
[TD]Product</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]P1</SPAN>[/TD]
[TD] [/TD]
[TD]X</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]P2</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[/TR]
[TR]
[TD]P3</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]X</SPAN>[/TD]
[/TR]
[TR]
[TD]P4</SPAN>[/TD]
[TD] [/TD]
[TD]X</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[TD]X</SPAN>[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL span=4></COLGROUP>[/TABLE]

 

[akmatz]

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

 

[lucidus]

The names of the Sheets will not change.