I have updated my post with a sample workbook, thank you for the direction. As you can see in the sample work book, In Sign Ups the Row 2 is filled out and they are a sponsor indicated in F2. I wish to have the entire row of information transfer to 'Sponsors' sheet if F2 is selected "Y"

With the header row 1, the best code I have come up with is:

=IF(FIND("Y",'Sign Ups'!F2)<>0,'Sign Ups'!F2,"")

But I need to include the f2 cell to include the entire range from A2:F2

That way it will preload the information to the Sponsors tab and save me a lot of time. Then in the sponsor's tab I can then just enter the specifics for that sponsorship. Thank you.