VBA to fill empty rows based on criteria from another sheet

Question

I am attempting to copy specific data from one sheet to another.

I think the steps would be: Enter the data into the quote tracking sheet If the job has been awarded then cell G will be YES Data will then be copied from Quote sheet to job number sheet. Each time that a new quote is approved, then that rows values will be copied.

When you select yes for row 4 in the quote sheet this rows values would go into the next available empty row in job number. when you select yes for row 6 in the quote sheet this rows values would go into the next available empty row in job number. when you select yes for row 1 in the quote sheet this rows values would go into the next available empty row in job number.

The big question is would this be better accomplished using VBA or Formulas.

I have several formula and sections of VBA code that copy the data but it just keeps copying the entirety of the data to sheet#2, not just the newest data.