Can't figure out a formula to copy selected rows in excel 2007

HI all!

Even though I have used many formulas recently I am very new to excel so excuse me if my question is a bit elementary. I have looked all over this forum but found nothing to fix my problem.

Here goes:

I need to be able to mark certain rows in my first column of my very long database and have only the marked ones move to the second sheet in my workbook. That's it in a nutshell. I put in a blank column in the first sheet and tried putting an "x" or a "^" and then using a search criteria but that didn't seem to work. I don't need the first column copied but I do need the other 14 columns (B-O) copied in rows. So, I have 471 rows of this worksheet and I might have only 3 marked. I need these 3 to show up on sheet 2 right next to each other. I don't even know if this is possible. Also, I don't know if I should use an "x" in the first column or a check mark. I had some trouble putting the check mark right in the cell. Any help is much appreciated!

Austin

Attached i have the example. I put N/A in all of the fields with confidential information. As you can see from the first sheet, some of the rows have x's. The rows with x's need to be moved to the second page.in descending order. At the same time, I need the first sheet to stay as is. Thanks so much for the help!