I have a lookup that returns a string Code name of a wks say sheet3

is there a way I can get a worksheet object referencing sheet3 from a string?

something like

Dim wks as worksheet
wks = activeworkbook.sheetsFromCodeName("Sheet3") ?

I think you're saying that you will have a variable that (using a lookup) contains the sheet name as a string, so you want something like:

Dim wks as Worksheet
wks = ActiveWorkbook.Sheets(VariableHoldingSheetName)