Help with IF function

Hi all,

I am looking for code advice to get my workbook how I wish.

About my workbook:
I have a two page workbook. 1st sheet is titled "Sign Ups"
Second is "Sponsors"

Sign ups contains the following info
A1 Company Name
B1 Address
C1 City
D1 State
E1 Zipcode
F1 Sponsor (YES or blank for no)

I am wanting to find a code that will take data from Sign Ups (1st sheet) and transfer to Sponsors (second sheet) if I type "YES" in the F1 Sponsor cell. I want not only F1 cell to transfer to the second sheet Sponsor but I want the entire row to transfer so I have all sponsor information on my second sheet Sponsors including Company name, address, city, state, zip, YES

So I have the code:
=IF(FIND("Y",'Sign Ups'!F1)<>0,'Sign Ups'!F1,"")
Which pulls the YES over but I need it to be a range to pull A1:F1 over if YES is typed in F1 cell.

I hope this is clear. Please help. Thank you!