I am new to excel.I have a problem which is explained below.

I have 2 excel sheets sheet1 and sheet 2.
sheet2 contains entry as follows

name1
col1 col2 col3
12 15 17

name2
col1 col2 col3 col4 col5
00 34 23 3 1
56 3 21 45 31

my sheet1 will have a list containing name1 and name2.if i select
name1 in sheet1,i want the rows below name1 to be fetched from
sheet2 and copied into sheet1.Since there can be many rows in sheet2
it is not possible to know the range(it is dynamic).

Also in sheet1 i have to get many rows.so there also the range of
cells where these rows should be pasted will keep on changing.these
rows from sheet2 need to be pasted one after another.

Can somebody help me to solve this problem?