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:

Data Source	EMPLOYEE	Sales Value A	Sales Value B
DS_1	123456	100	125
DS_1	123457	150	300
DS_2	123456	200	250
DS_2	654322	250	300

<tbody>
</tbody>

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.

DS_1	DS_1	DS_1	DS_2
Employee	Value A	Value B	Value B
123456	100	125	250
123457	150	300

<tbody>
</tbody>

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