Calling all Table experts - a tricky issue I need help with!!

[Mr Excelinator]

Hi all.

Have a question,

Is it possible to "load" an excel table so it expands based on a filter criteria from another dataset via a lookup?

So imagine I have source data set up as follows:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Data Source[/TD]
[TD]EMPLOYEE[/TD]
[TD]Sales Value A[/TD]
[TD]Sales Value B[/TD]
[/TR]
[TR]
[TD]DS_1[/TD]
[TD]123456[/TD]
[TD]100[/TD]
[TD]125[/TD]
[/TR]
[TR]
[TD]DS_1[/TD]
[TD]123457[/TD]
[TD]150[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]DS_2[/TD]
[TD]123456[/TD]
[TD]200[/TD]
[TD]250[/TD]
[/TR]
[TR]
[TD]DS_2[/TD]
[TD]654322[/TD]
[TD]250[/TD]
[TD]300[/TD]
[/TR]
</tbody>[/TABLE]


I than have another table which is looking up & comparing that data in various permutations (pivot tables don't work for this)

So the below is what I am trying to achieve, I want to set the base table population (automatically) by selecting my data set - in this case A, so Employee 654322 is not on the list. Then I want to be selective in looking up data Value variants, so in this case I've selected Value A & B from DS_1 & Value B from DS_2

- pulling all that in by index match against the source data.

So in the first column If I selected DS_2 I want to display 123456 & 654322 as the base lookups the table would adjust accordingly.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]DS_1[/TD]
[TD]DS_1[/TD]
[TD]DS_1[/TD]
[TD]DS_2[/TD]
[/TR]
[TR]
[TD]Employee[/TD]
[TD]Value A[/TD]
[TD]Value B[/TD]
[TD]Value B[/TD]
[/TR]
[TR]
[TD]123456[/TD]
[TD]100[/TD]
[TD]125[/TD]
[TD]250[/TD]
[/TR]
[TR]
[TD]123457[/TD]
[TD]150[/TD]
[TD]300[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Hope that makes sense!
Any expert opinion greatly appreciated in advance.
thanks.
Stu