Calculations across multiple sheets

[teelee72]

Hello Everyone!
I have quite a daunting task to perform. I have a spreadsheet with: 1.data divided into categories (by date, site, number, products); 2. within the cell are contained alpha/numeric; 3. I need to calculate that field (alpha/numeric); 4. the location of these items are on several sheets (22) that needs to be calculated; 5. Can this data be combined on one (1) page. I know this is a lot to ask, but if I cannot find an answer, I will just have to try and calculate each page. The data was already set-up,so it was inherited. Any assistance would be gratefully appreciated. Below is an example and the Products column has to be totaled. The locations are on several sheets, so I need to get a total somehow.

Thank you, Thank you Thank you for any assistance, and have a beautiful day!

[TABLE="width: 467"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Delivery Site[/TD]
[TD]Prod-No.[/TD]
[TD]Products[/TD]
[/TR]
[TR]
[TD]Monday, May 25, 2015[/TD]
[TD] N/A[/TD]
[TD]N/A[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tuesday, May 26, 2015[/TD]
[TD]Human Resource[/TD]
[TD] SN-53845[/TD]
[TD]20 Tablets[/TD]
[/TR]
[TR]
[TD]Maintenance[/TD]
[TD] SN-54066[/TD]
[TD]6 Drills[/TD]
[/TR]
[TR]
[TD]STS[/TD]
[TD]SN- 53845[/TD]
[TD]5 Cabinets[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Wednesday, May 27, 2015[/TD]
[TD]Cafeteria[/TD]
[TD]SN- 53719[/TD]
[TD]30 Tables[/TD]
[/TR]
[TR]
[TD]ATTC[/TD]
[TD]SN- 53477[/TD]
[TD]10 desks[/TD]
[/TR]
</tbody>[/TABLE]