Just looking at your question, I don't believe there is a worksheet function
that can accomplish what you want without some programming. So in your case,
there are many ways to go about how to do this. Since there are 100 lookups
to be done, you will most definitely need a Loop of some sort. You should
post this in the Programming Section.

"Peter" wrote:

How can I get VLOOKUP to look at a cell which contains the name of a
Worksheet, from this, get it to look at a the same named Worksheet and do
its "looking".
The aim is to avoid creating individual 100 VLOOKUPS that each need to look
at a unique worksheet (the base worksheet already has 100 worksheet names
typed into col A). This would then sum up common criteria (numbers) found in
those worksheets?

This is what I've tried, unsuccessfully: =
VLOOKUP(A6,INDIRECT("A5")$B$6:$C$10,2,FALSE).

I know that =INDIRECT(ADDRESS(6,2,,,B1)) will find info in another
worksheet, based on looking at a worksheet name in cell B1, but I can not
get this function to join up with VLOOKUP.


Thanks

Peter