I have a workbook with many sheets and for every sheet I want to lookup the
values of multiple cells. With the address function I can create which cells
I want to lookup; but how can I get the value in those cells returned?

short descriptive:
worksheet names are 3039, 3058 (and more)
cell B2 of each sheet contains a name (say name is EXAMPLE on sheet 3039 and
EXHIBIT on sheet 3058)
cell B4 of each sheet contains a number (say number is 250 on sheet 3039 and
430 on sheet 3058)
I want to create an overview on a new sheet that shows me the values of
those cells.

--
van0710
*to beautiful years in a beautiful city*