How to copy cells in a row if output of a cell in that row is positive

Hi any help would greatly be appreciated - i have on Sheet1 many customer details eg name, company, telephone, email address, job requested, quote given etc and Outcome. I want to copy to Sheet 2, customer name, company, telephone, email, and job requested only if the Outcome is "Accepted" - this part i have managed to do with a simple If function. However the problem is that on Sheet 2 i only want to copy over accepted jobs one after the other which i cannot get to work. my formula scans each row and returns the correct information if Outcome is Accepted otherwise returns FALSE can anyone please assist Thank you in advance.

=IF(Quote!J6="Accepted",Quote!E6,"") this is the formula i am using but only checks one row at a time and if Outcome is not "Accepted" it leaves me a blank row but instead i want to display Accepted quotes only one after the other

i am using 2007 version