How to reference a different worksheet's title in a formula

[markmarhon]

Is it possible to reference the name of another worksheet in a formula?
For example, if I have a set of data with fields for January, February, etc., and have tabs that are named January, February, etc., and I want to lookup data in those tables based on the month specified in the field, is there a way to reference the field name to populate the different worksheet name in the formula?

 

[Joe4]

Welcome to the Board!

Yes, you can use the INDIRECT function for that.
See: http://www.cpearson.com/excel/indirect.htm
and https://www.ablebits.com/office-addins-blog/2015/02/10/excel-indirect-function/

 

[jim may]

At its simplest...


Excel 2010

	A	B
1	My Sheet Named	Cell E6 Value
2	Z00001	ABC

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Data​

Worksheet Formulas Cell Formula B2 =INDIRECT($A2&"!"&"E6") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>