I am attempting to reference a sheet within a work book using VBA code. Generally it looks like this:

Sheets("SheetName").select

but I would like to reference I sheet name that I input into a cell in one of may sheets call it B2. Thus, I want the code to look something like

Sheets("B2").select

I have tried naming the cell but it does not work.

Any suggestions?