Hi all! I am new to this forum and I am very excited about all of the talent that I see here. It has been years since I have coded and now I am just starting again. I am trying to use a vlookup to find the name of a worksheet that I want to call. I have the lookup working as I have a msgbox that shows me the name of the worksheet is stored in the variable, but for some reason it will not allow me to select the sheet so that I can run the rest of the macro. The very bottom line is where I keep striking out. I have looked at so many posts and tried so many different variations that I am now really confused. Any help you can give me would be greatly appreciated. 

Sub Repair_Formulas()
'
' Repair_Formulas Macro
'

Dim week
Dim ShtNme As String
Dim Select_Sht As Workbook
Dim Sht_Rng As Range
Sheets("Calcs").Select
week = Range("X2")

ShtNme = Application.VLookup(Range("Calcs!AA2"), Range("Calcs!N3: S13"), 6, True)
Msg1 = MsgBox(ShtNme)

Set Select_Sht = Sheets(ShtNme)
Thanks in advance for your miraculous (all be it easy for you) answer!