CONDITIONAL COPY TO NEW SHEET

I'm working on a Excel file with three sheets. All have the same colums, just different sheet names. The last two colums for each sheet reflect the customers intention to purchase separate tickets to an event and will contain a numerical value. If either of those cells are populated, how do I copy that info to a new sheet along with a filtered selection of other colums from that same row, i.e. name, credit card number, expiration, etc.