find/copy/paste-append to a different sheet

I need to find/copy/paste and append each row containing a specifc value to a new spreadsheet. Each value may contain 100 lines or so. I also need to do it for multiple values. Can anyone help? I am using Excel 2007.