hi

i am trying to reference the same range in a vlookup on a variety (20+)
worksheets.

i can reference a particular cell using the indirect function but i want to
link to an area (say B3 to D8) on each of the worksheets and then conduct a
vlookup on this grid. i have a list of the worksheet names on a summary
sheet and am attempting to pull data from the same area on each individual
worksheet onto the summary tab.

my attemp which was =vlookup(B2,indirect(A2&"!B3:D8"), 17,false) doesn't work.

for some context
b2 contains an item of output which comes from the a2 processing option
i have a long list of processing options with items / outputs and i want to
bring in the costs calculated on the worksheets for each of these processing
options