Extracting data related to a single month from a whole range of data

I have a problem I have found to avoid solving for ages now, but I think the time has come.

I have a sheet called input which will have data added to it on a daily basis.

At the end of each month I have to submit a report which shows the data relating to that month. I also have to show a rolling total (all previous data + new month).

Current - NOT ideal solution

I have to set up about 2 years of separate work sheets and manually change all of the formulas to read the appropriate data from the input sheet. At the end of the 2 years I then have to create more sheets. Also I have to copy the formulas down the input sheet to around row 10,000 as the could be 30 entries a day. This makes the workbook farily large even when it isn't even populated with any useful data.

Is there a more elegant solution to all this?

I have attached an example fil, I have had to strip a lot of data out and there are only 2 monthly sheets shown otherwise the file exceed the upload limit.

I would be more than happy if the sheet only generated THE currents months summary sheet plus the running total.


any help much appreciated.