Using Formula

=IF(Sheet1!A2="Y",Sheet1!B2,"")

Which is perfect! I need it to skip cells that do not =Y rather then incert a blank cell.

Thanks