ideas for automatization of the file

Hello everybody,

I'm facing a big challenge, I have to make everything as simple as possible. The problem is handling the fresh data. I've made a sample file, how it should all look like. I'm gonna explain my problem now.

For the purpose of this request the work "Arkusz" means Sheet. In "Arkusz1" I have an entry data(in columns A-O) the rest is needed to be calculated, but luckly table does that. In "Arkusz2" I've made a pivot table that creates vital data for the rest of the analysis. In "Arkusz3" we have copied data from pivot and I'm making crucial calculations over there. The whole issue is, I would like to make this calculations always for the data for the freshest month, in sample I've made that by hand for the June, the formulas are included - for how their should be calculated. Anybody maybe have an idea how to make that automatic(when I'll add a data for July the file will make this calculations for July not June)? In case of any questions do not hesitate to ask. Kind regards.

Sample is included.