Help w/ Worksheet Function

Good afternoon experts.

I've been hitting my head against an iron pole the last couple of days looking for the best way to create a worksheet function that will allow me to copy and paste some cells from another sheet within the same workbook to create a transmittal form. I have zipped an excel file to try to explain my goal.

Basically what I want is the user to type the number of the "row" (i.e 6) on the transmittal sheet and the worksheet function to pull certain info from all the rows below the one typed (i.e. 7, 10, 12, etc) in the User sheet in which column E is equal to "y."

I bet someone can do this in like 5 mins.

Thanks in advance guys and gals.

- Nrage -