Hi there, some assistance if possible.

I have 200 names in column A on a sheet1. Each name can have upto 10
entries.

I would like to reference five names that are on sheet2 and copy the
rows from sheet1 for each name onto sheet3. So I would then have
approx 50 rows with all of the names I require.

Hope someone can help, and understands!!

Many thanks,

Bob.