Not sure what you exactly want but this may point you in some sort of a
direction:

If say the something you wanted to look up in Sheet 1 was names and dates in
cells A1 to B6:
names ages
fred 23
ada 76
jane 42
jack 36
jill 24


and in your new worksheet (Sheet2) you entered the name of the person you
wanted to find the age for in A1; say
Jane. Then in cell B1 on Sheet 2 enter the following formula:
=VLOOKUP(A1,Sheet1!A1:B6,2,FALSE)
you will see that the answer in B1 is 42.
Now if you change the name in Cell A1 on Sheet2, you will see the age change
accordingly

Hope this helps
Philip
"jhow" wrote in message
...
I want to do a lookup using a list of sheet names in a workbook. For
example
I want to lookup something in 'Sheet1' and refer to a cell.