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!!

I used that formula in the example spreadsheet and it is still just returning the first row, not the rest of them...Am I missing something? Should I be copying the formula all of the way down?

Okay, so I figured out what I needed to do to make that formula work. My only question is if there is any possible way to make this happen without having to put a formula into each line? The way I understand the OFFSET function, it should work out, but I can't figure it out. I got it to work for me when returning just one row, but not for multiple. Suggestions?