Copy data from multiple sheets to one main based on cell value

I am brand new to the world of macros. I work for an automotive dealer. We want to take the attached spreadsheet, and if the value under "progress" says "Sold" I want that row to be copied to the sheet "Main", but keeping the numbering system in tact in Column A. I hope this makes sense. I've been playing with this for about 2 weeks.

Thanks
Jason Mitchell
Classic Beaumont
409-924-3417