Hi and thank you!

To be honest, I am not too familiar with Pivot Tables. However, I tried to use them, but I chosed not to use them becouse it is not guaranteed that the data source's size is constant.

I also cannot use a named range, becouse I have to create a template, and the user will create worksheets from the template by copying them and renaming it corresponding to the current month. (I do not know how can I create a dynamic named range what also renames itself, without VB code, what I was told not to use.)

But since I am not into Pivot Tables, I am unsure if I am missing the easier way here. I also have to create datas for the whole year from the individual worksheets. (This is now done by copying the final data with formulas.)