I have created a new worksheet within a workbook. Currently I have 5 other sheets within the same workbook, each with multiple products. However, some of these pages have the same listing and description from the same company (ie. hand towels, soap, etc.) and it is done that way because it is for that particular worksheet (ie.sports equipment like baseball, basketball, track, etc.) I need to create a way to post that single product appearing in multiple worksheets into a single worksheet, which would also give me the total number of orders for this particular product, unfortunately, I'm not sure how to build a formula to do so. Any thoughts on how can I do this?