Selecting specific range of cells based on current month

Hello,

I am currently trying to automate a process at work.

In the workbook attached, under the column labelled YTD (Cell O4), I have to update the formula to include the current month (July), this process is repeated each month.

I am wondering if there is a way to automate the process through a macro so that Excel knows that it needs to pull the sum of Cells B:H if it's month of July. Cells B:I if its the month of August etc. etc.

Please let me know if you need additional clarification. Thanks in advance for your help.

Sohshak