Excel sheet name from a cell value
Posted on 2013-12-03
I have a workbook that includes several worksheets that are each named with a unique identifier.
One of the sheets is my summary page that references values form each of the sheets. Because it is a pain to write out the name of the sheet each time I copy a formula I would like to grap the name of the worksheet from a value.
for example something like this is in cell B3
so if B2 on my current sheet is 'cjs123' then the formula should go to the sheet called cjs123 and retrieve the value in cell B3.
How can I create this functionality?