Excel fx for dates

I have a master sheet (Intake Documentation) and a cell that I update monthly(G10). I want that cell to update another sheet (YOQ) that has a cell for each month. I know I can link one cell to several cells on another sheet but how do I get the cell on my YOQ sheet to only display the range for that particular month?