Consider only first matching and copy Row

I can't think of any way to autopopulate Sheet3 without first adding helper columns to Sheet1 to determine if Sheet1 values match Sheet2.

Hopefully someone else can be of further assistance.

edit: You could put a filter on Sheet3 and just filter out the #VALUE!