VBA button to generate numbers based on formula

Hi there,

Is this possible with VBA? Please see the attached.

I would like to first select a period and then hit that button to generate numbers in the green highlighted cells.( I have highlighted them for you to see easily) Also, I have left the formula in the formula bar for you to see. (these are formula I have been using in standard formula bar). You may notice that I am essentially using the period as a filter in the formula argument.

So I'm trying to have those formula built in the VBA backend. When the button is clicked, Excel will populate the table based on formula used.

Is this possible at all?

Thank you