Pull all needed data from sheet 1 to sheet 2 / dropdown / based on 1 column in sheet 1

[lotrev]

Hi!
I have sheet with data for different people. I want to make some kind of drop down function in sheet 2, which looks on column B with people names in sheet 1.
Main thing is I want to get many cell data from specified row(from dropdown) as well. And data goes to different locations in sheet2.
Long story short: I need to get this rows data and make like an overview paper in sheet2, so I can print it.

Sheet1
NAME1 DATE HEIGHT VALUE1 VALUE2 ... VALUE20

Sheet2
Dropdown NAME1
NAME2

then


NAME1 DATE

VALUE1 HEIGHT




VALUE5 VALUE6 VALUE7

Something like that

 

[AlanY]

something like this?

Book1
	A	B	C	D	E	F	G	H	I	J
1		Value 1	Value 2	Value 3	Value 4	Value 5	Value 6	Value 7	Value 8	Value 9
2	Name 1	Data 11	Data 12	Data 13	Data 14	Data 15	Data 16	Data 17	Data 18	Data 19
3	Name 2	Data 21	Data 22	Data 23	Data 24	Data 25	Data 26	Data 27	Data 28	Data 29
4	Name 3	Data 31	Data 32	Data 33	Data 34	Data 35	Data 36	Data 37	Data 38	Data 39
5	Name 4	Data 41	Data 42	Data 43	Data 44	Data 45	Data 46	Data 47	Data 48	Data 49
6	Name 5	Data 51	Data 52	Data 53	Data 54	Data 55	Data 56	Data 57	Data 58	Data 59
7	Name 6	Data 61	Data 62	Data 63	Data 64	Data 65	Data 66	Data 67	Data 68	Data 69
8	Name 7	Data 71	Data 72	Data 73	Data 74	Data 75	Data 76	Data 77	Data 78	Data 79
9	Name 8	Data 81	Data 82	Data 83	Data 84	Data 85	Data 86	Data 87	Data 88	Data 89
10	Name 9	Data 91	Data 92	Data 93	Data 94	Data 95	Data 96	Data 97	Data 98	Data 99
11	Name 10	Data 101	Data 102	Data 103	Data 104	Data 105	Data 106	Data 107	Data 108	Data 109
12
13
14	Name 4
15	Value 1	Data 41
16	Value 2	Data 42
17	Value 3	Data 43
18	Value 4	Data 44
19	Value 5	Data 45
20	Value 6	Data 46
21	Value 7	Data 47
22	Value 8	Data 48
23	Value 9	Data 49
Sheet8

Cell Formulas
Range	Formula
B15:B23	B15	=INDEX($B$2:$J$11,MATCH($A$14,$A$2:$A$11,0),MATCH(A15,$B$1:$J$1,0))

 

[lotrev]

The data sheet looks like this

And I want to select person for printable version

For now I found solution in google sheets. I use this formula to extract needed persons data to Sheet1:
=array_constrain(QUERY(ImportRange("1mdQT92olBcQWWyhEwbekj0iDTHwTdlS-iA4SURHOFZI","Testi!A:BB" ),"select * where Col1=1",0),3,52)

But it doesn't work in excel.

 

[lotrev]

So yeah, I need some kind of IMPORTRANGE alternative for excel. Is there any?