Is it possible to use the vlookup function to reference a worksheet?. Ie I
have a workbook with three sheets in it, named peter,paul and mary. There is
also a master sheet.

On the master sheet, I have a drop-down list (in cell A1) that lists
peter,paul and mary.

I want to be able to use a formula such as =VLOOKUP(A1,A13:B19,1,FALSE).
how do i get the worksheet names,

ie 'peter'! 'paul'! and 'mary'! in the drop down list?


Any body any ideas?