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?