Master Sheet.xlsm

Hello,
I have a spreadsheet, attached, where I would like to pull information for a given date and Period (again, see attached for reference).

For example, I would like to pull up any person that has an "x" for Thursday June 27th Periods 1-6. The next day, I would want to run the same thing for Friday, June 28th periods 1-6. So I need to be able to input the date I would like the formula to output. Possibly by means of cell reference so I can make it easy to find the date I need.

Thanks,