To summarize and report results from separate worksheets, you can consolidate data from each into a master worksheet.The worksheets can be in the same workbook as the master worksheet or in other workbooks.
Questions on Stack Overflow are expected to relate to programming within the scope defined by the community.
Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope.
There are many ways to consolidate data in Microsoft Excel.
You can use the Table feature and its associated filters to filter a list so it shows only those items you are interested in seeing and you can create Pivot Tables to look at your data in different ways.
This master worksheet might also contain sales totals and averages, current inventory levels, and highest selling products for the entire enterprise.