I have a worksheet with separate tabs for each day of the month.

The tab/worksheet for each day has several pieces of data (all in columns)
that need to be Pivoted out to show the information per day.

For example on July 1st:
Column A - Storefront
Column B - Product
Column C - # of orders for each of the Products and Storefront defined in
A&B.

The info in these columns will change by day depending on the orders
actually made by customers. The tabs (days) are not identical with the
Storefront and Product (due to the macro the programmer put in to compile the
data from a raw data sheet)

I need to somehow create one Pivot table that will reference each tab (day)
and pull back the following data:

Storefront
Product
Date and number of orders for each Storefront/Product.

The finished Pivot Table should have (in the case of July - 31 days listed
in it) with the total orders listed by day for each storefront & product.

Any ideas on how to accomplish this?