Return Range of Cells whose title matches given cell

I apologize if this is answered somewhere, but I have been unable to locate the solution to my problem.

I am attempting to streamline my task assignment and have run into a problem. I have set tasks for specific days of the week. I have designed a workbook with tabs for each day of the month. There is an additional sheet for which determines the first day of the month using EOMONTH(TODAY(),0)+1. I use this within the WEEKDAY function to obtain the day of the week. What I want is to have a formula that will check the day of the week on this tab, then find the matching day in a tab where each day's tasks are detailed using the same format, and return all 15 rows for the day. Each day has 15 rows, even if they are not filled up.

I have tried using IF and just checking for each day of the week, matching with the day on the master sheet, but it will only return one row. I also tried to use the OFFSET(MATCH) function, but it was either not computing or returning #VALUE.

One of the formulas was OFFSET(MATCH(G6, Ranges!A:A,0),0,0,15,1) and this one wouldn't even finish.

Help!!