Filter Data sheets and include results on dashboard with graph

Good Day,

Hope this message finds you well. I need some assistance with the following.

I have attached an example sheet of what I am trying to achieve.

I would like to select a project current gate within the ComboBox (as per the dashboard) and then it’s should return the number of projects (all sheets) within that specific gate into the label on the dashboard.

I would also like to then show on a graph the number of projects (that was filtered by the above) within each month and year according to the column “Next Gate Target Date”. It should be then be paste within the image box on the dashboard.

I will truly appreciated it if someone can help me with this, as my VBA is very limited.

I thank you in advance.