I have a workbook that is 62000 rows long and contains lots of information including numbers and text. I have been searching all day, and can't seem to search the right phrase to get the answer I need, so please forgive me if this is elsewhere. Basically I would like a macro to search for ALL occurrences of the four different numbers and copy the entire row onto a new sheet. I have found examples that will copy it once, or all occurrences in a specific column, but my numbers could be in any column and I need every time that any of the four different numbers would appear to be copied to one single sheet separate from the rest of the information. ANY HELP APPRECIATED! I have attached an example sheet, that does not use the correct numbers. I'm very VERY knew to this so please use small words with me

So, in the example I would need every time the number 1234567891 appeared anywhere in the sheet, the entire row to be copied to a new sheet except in real life I have four different numbers to search for. example.xls