Within a Vlookup

=vlookup(lookup value, indirect("'"&reference cell for tab name&"'!array:array"), column #, false)