VLookup referencing a tab name?

[Scoty]

Hi

So, i have 4 sheets on one workbook, lets call them "Alpha", "Bravo", "Charlie", "Delta" each with lots of similar but slightly different data.

On a fifth sheet, i want to:

- Enter the name of one of the tabs (above) in cell A1
- Then in cell A2, be able to carry out a vlookup, using firstly the sheet name just typed into A1 to find the correct tab, followed by all the usual vlookup criteria.

- Additionally, would this still work if A1 was selected from a drop down rather than free text entry?

Sounds like it should be fairly simple? Formula please?

Thanks.

 

[Aladin Akyurek]

Example usage:

=VLOOKUP(lookupvalue,INDIRECT("'"&A1&"'!A:D"),2,0)