Use a Cell as an Address for another sheet?

[sforney123]

I am running Excel 2010. I have a large data set where I have list of information across the top (Row 1) that matches the name of tabs in my workbook. Is there anyway to get the info in Row 1 to popluate the address when I do a vlookup on a different tab. So I could drag a formula across insted of having to do a find an replace. For example:

This is the formula that works
=VLOOKUP(B171,ACK!A3:B3,2,FALSE)

Could we replace the ACK in the vlookup with the cell info so

=VLOOKUP(B171,C1!A3:B3,2,FALSE)

So if I were to drag the formula to the right it would look like
=VLOOKUP(B171,C2!A3:B3,2,FALSE)

I tried the INDIRECT and Address combination but that didn't work:
=VLOOKUP(B171,INDIRECT(ADDRESS(1,3))!A3:B3,2,FALSE)

[a31185]

the indirect function should reference the entire array
try

=VLOOKUP(B171,INDIRECT(C2&"!$A$3:$B$3"),2,FALSE)

[sforney123]

Thanks that did the trick.