Tabulate through dropdown

[Vtookup]

Hi all.
I learn a lot from Michael Girvin's videos. This one (EMT967), I'm curious if I can expand table to maybe 10 tables in same columns and can be tabulated by dropdown? Is this doable? can anyone guide me to a solution? Thank you. please see example.

Excel 2007 32 bit

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Top	5	<	<	<	<		<< Extract value				Top	5
2	Hurdle	63				A		<< Dropdown				Hurdle	=LARGE(A6:A12,B1)
3	Count	6										Count	=COUNTIF(A6:A12,">="&B2)
4	A
5	Visits	Manager		No	Visits	Manager						No
6	91	AA		1	100	AG		<< results				=IF(ROWS(D$6:D6)>$B$3,"",ROWS(D$6:D6))
7	63	AB		2	91	AA
8	75	AC		3	82	AD						Visits
9	82	AD		4	75	AC						=IF(L7="","",LARGE($A$6:$A$12,L7))
10	63	AE		5	63	AB
11	27	AF		6	63	AE
12	100	AG
13												Manager
14	B											=IF(L7="","",INDEX($B$6:$B$12,SMALL(IF($A$6:$A$12=M7,ROW($A$6:$A$12)-ROW($A$6)+1),COUNTIF($E$6:M7,M7))))
15	Visits	Manager
23
24	C
25	Visits	Manager
33
34	D
35	Visits	Manager
43
44	and so on…

<tbody>
</tbody>

967​

 

[Vtookup]

Sorry i messed up with attachment
formula for visit is

 =IF(D6="","",LARGE($A$6:$A$12,D6))

while MAnager is

{ =IF(D6="","",INDEX($B$6:$B$12,SMALL(IF($A$6:$A$12=E6,ROW($A$6:$A$12)-ROW($A$6)+1),COUNTIF($E$6:E6,E6))))}