Help: I need a sheet to be opened based on a cell value
 

I have a dialog box that I am using to pull up a specific sheet in my
workbook. It has 2 option buttons, one for week 1 and one for week 2, then
it has a dropdown for the day of the week. I then use the concatenate
command to combine the day and the week in the ref cell. My question is...
How do I get the sheet that the cell name is referenced to open when I click
the OK button?