Keeping daily forcast record for whole month

Hi, i needed suggestion on our current practise.

Currently, we have a daily forcast of receipt. Each tab has 01/05/2019-31/05/2019. (31 Column). Example, on 01/05, the person will input the forcast for 02/05-31/05 and put the Actual receipt for 01/05 in a seperate row.
The next day. 02/5, the person will duplicate sheet01/05 and forcast 03/05-31/05 and put the actual receipt for 02/05

So at the end of the month, we would have 31sheets which i think is very messy. However, we need to keep record of our daily forcast.

How should i arrange my data more efficiently (preferably one sheet)? So that i can easily refer back to my previous forcast? Refer attached for simplified example

If you layout your data on a single sheet, you can analyse your data using pivot tables to create your reports.

Something like these headers as a start;

Name - Date - Forecast - Actual