I'm having trouble finding the code to use within a macro to select a
worksheet based on the value entered into a certain cell.

What I have is a worksheet for entering data and a macro that organizes and
copies the data to other sheets, one being a catch-all for all data and
another being a sheet corresponding to a specific value entered in B2.
Options for data in B2 are validated from a list in another sheet, and a
worksheet of exactly the same name already exists for each option available
in B2. I just need the macro to choose the sheet corresponding to B2.

2nd question: Is it possible to change a specific sheet to manual
calculation, or must the calculation method selected always affect the
workbook as a whole?

Thanks all.

Ryan