extract from multiple worksheets
 

Hello,

I have a file with numerous worksheets containing the same information.
Each worksheet represents a date range, ie, 1.3_1.9, 1.10_1.16, etc...

In each worksheet, there is a summary field that I want to extract and bring
into a Totals sheet. What I am trying to do is something like a vlookup, but
rather I want the vlookup to go to the different worksheets and pull the
information that I want.

In my totals sheet I will have the following fields:

Date: Percentage:
(same as worksheets tab name) vlookup(

Another and faster way to do it, which I hope, is to create a macro that
will run through the different worksheets and bring the information back to
my Total sheets (ie, for i=1 to x then, next i)

Thanks for your help.