I need to create a summary on one new sheet that pulls from multiple sheets

mattatkobes    One question you will get right off the bat from most of us here is "Why do you have 50 sheets in that workbook?" Why not assemble them all into a single sheet? If the columns are the same in each, but there's some other factor--whatever it is--that differentiates each sheet from all the others, that "factor"--again, whatever it is-- could be reflected in a single NEW column added to the columns of each.

Once the various rows from all 50 sheets are together in one large sheet, it would be simplicity itself to sift the entire long database on Column S, looking only for those rows that reflect a saleable product. And you would have your summary report.

If you want more help, it would help me (and others) if you would upload (without violating any proprietary info) samples of at least, say, three or four of your 50 sheets.