Thank you for your help.

I believe that would work but why I am actually trying to do this is that I have about 50 worksheets that have a form in the sheet. When completing the form if a "1" is in a certain cell in a row it would copy it and the two cells to its right down to a cell below the form starting at B50. After each worksheet form ran a macro then all of these worksheets that met this condition are copied to a separate worksheet "Out of Safety Compliance" starting at cell B2. Hopefully I didn't confuse this even further