I have information on many worksheets that are tied to if then formulaes.
So, I may have 30 rows of information but only 5 fit the criteria. This
would be the same for about 10 sheets in one workbook. What I want is for
the pieces of information that fit the criteria to be pulled from each of the
worksheets into one final worksheet.