Same items in different worksheets put into a single worksheet.

[Bigwilliewilcox]

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?

[JuJuBe]

A sample workbook would be helpful, I'm not sure we're following you. If all you want to do is create a summary page it can be as easy as a formula that refrences the totals from each worksheet. Let's assume your data is in columns and you want the total of 4 different "Hand Soap" columns on 1 page. If the hand soap column is in column B of each worksheet, enter =SUM(B2:B#) at the bottom of the column on each page, (replace # with last row of data in column B). The formula on the summary page for hand soap would then look something like:

=SUM(sheet1!B#,sheet2!B#,sheet3!B#,sheet4!#)

again, replace # with the cell sontaining the =SUM formula from the bottom of each 'Hand Soap' column.

[Bigwilliewilcox]

A sample workbook would be helpful, I'm not sure we're following you. If all you want to do is create a summary page it can be as easy as a formula that refrences the totals from each worksheet. Let's assume your data is in columns and you want the total of 4 different "Hand Soap" columns on 1 page. If the hand soap column is in column B of each worksheet, enter =SUM(B2:B#) at the bottom of the column on each page, (replace # with last row of data in column B). The formula on the summary page for hand soap would then look something like:

=SUM(sheet1!B#,sheet2!B#,sheet3!B#,sheet4!#)

again, replace # with the cell sontaining the =SUM formula from the bottom of each 'Hand Soap' column.

Sorry JuJuBe,

First, Thanks for replying....lets see if I can explain better.

I have 1 workbook, it's entitled Fall Sports.
Within this workbook, I have 5 worksheets.
1) Volleyball
2) Soccer
3) Phys Ed.
4) Football
5) First Aid

Within each of these worksheets, are Item numbers, Manufacturers, Descriptions of products, and then numbers ordered by our customers. Some of these items repeat within each workbook, for example, you might offer a hand towel made by Dupont or something, and everything is the same, except the item number (football might be FB116, while Volleyball might be VB220). What I want to do is create a formula, that puts those like items into a single sheet. I know how to total the sums for the numbers ordered within the sheets (though it would be nice to have a shortcut there too), but what i don't know is how to create the sheet with a formula that will look at the others and grab those like items and put them in those fields. Sorry if this is about as clear as mud...but it's the best I can do at the moment.

R