Summarizing Daily data from multiple sheets; then calc Month to Date for any day

Assume that I am running a gas station. I am only selling 4 grades of fuel: Regular, Mid-Grade, Premium, and Diesel.

I am challenged to create a file that includes a summary tab with additional tabs for every day of the month. Feb 1 data is copied from source document and pasted into tab "1"; Feb 2 data is pasted to tab "2"; etc. Each of the daily tabs are consistent from the source data.

The tab "Summary" is a consolidation of the daily data. We are comparing each item's budget to actuals.

trial1.PNG

I can calc the daily data by using a sumifs and indirect to get the data from tab "6". I can calc the Month to Date (MTD) if all tabs are to be included.

Assume it is now Feb 18 and all tabs"1" through "18" are populated. Where I am being challenged is to calc the MTD data on a day earlier in the month. I need to be able to calc the MTD through Feb 5.
My first inclination was to have the tab "Summary" store the the data in 31 consecutive columns that are hidden, but that seems to be storing redundant data.
How do I only calc the MTD through Feb 5 if I have already populated the data for 18 days?

On a side note:
As we expand our gas station into a convenience store, we will be adding other groups of items such as Candy, Drinks, etc. These will be added to the summary sheet as we expand.

Personally i think having a separate worksheet for each days data is a bit exuberant and makes analyzing data a lot more difficult. I would personally have a summary tab and one data tab with all information on it.
As for your current problem its hard to come up with an exact solution for you without a mock spreadsheet. The best i can do is suggest using a =choose() function.
maybe have a date cell that you want to calculate your MTD by and use a day formula to get the day to use for your choose function. =choose(day(F3),tab1,tab2,tab3,tab4...etc etc)

Thanks dosydos for the response.

I have oversimplified the gas station with only 4 products.
In reality we have hundreds of "Items" in many "Item Groups" that require daily comparisons to our budget.
To keep all data on a single sheet would provide significant opportunities for operator error. I want to avoid the error possibility.

On the tab "Summary" I need to calc the selected Day data and the selected day MTD data.

Tab "1" through "31" looks like this
trial2.PNG

Tab "Summary" looks like this
trial3.PNG

On the "Summary" tab, I can calc the selected Day (Cell C14) data using the Sumifs and Indirect functions.
How do I calc the Current MTD (column E) through the selected Day (cell C14) if all 31 tabs have data in them??

JeteMc, thanks for the response.

I guess I am not quite explaining myself.

In the attached file, I would like to change the date in cell C1 to any day of the month and column D will automatically recalculate the Current MTD amounts.
There may be 29 days with data, but I would like to go back to Jan 2 to review our sales results.

My current formula will sum Every Day with sales (in the example 3 days of sales).
If I change the date in cell C1 to Jan 2 (as shown in cell C29), the MTD column should recalculate to only include 2 days (as shown in D42 through D51).

Thanks JeteMc.

Sorry that I misunderstood your usage of the "End" tab. Now I understand.
That will have to work. I was hoping for a 1-step process to have the MTD recalculated by simple input of a date.

thanks again for you efforts.