Cells in address

I need to use a cell entry as part of the link address for another cell in
the same sheet. Cell A1 of Data Input will show only the Month. Each tab in
the workbook has a month as the sheet name. Cell B2 needs to link to the tab
of the same name as A1 but point to cell C1 of that sheet. Is there any way
to have this happen using a basic formula instead of VBA?

try using indirect where cell A1 equals the month name. This should resolve
to, using January as an example =January!C1

=INDIRECT(A1&"!c1")

"3PLEngineer" wrote:

> I need to use a cell entry as part of the link address for another cell in
> the same sheet. Cell A1 of Data Input will show only the Month. Each tab in
> the workbook has a month as the sheet name. Cell B2 needs to link to the tab
> of the same name as A1 but point to cell C1 of that sheet. Is there any way
> to have this happen using a basic formula instead of VBA?