You post isn't as clear as it needs to be. First, assuming your
summary sheet has data like

01.02.08 EAS
02.02.08 EAS
02.05.09 LIN

Should the search routine look only in the worksheet named in column A
as it loops down the columns on the summary sheet? That is, should it
search only sheet 01.02.08 for "EAS", then search only sheet 02.02.08
for EAS and then search only 02.05.09 for LIN? Or should every
worksheet be searched for every code?

Next, it is a relatively simple task to search the appropriate
worksheet for the text "EAS", but what does "return the individual
values into the summary sheet" mean? Suppose the code found "EAS" in
cell A3 on one of the date sheets. How then does it find the
associated value? In your example, you show the value 44 as related to
EAS on the 01.02.08 sheet. Where does the 44 come from? And if there
are multiple occurrences of EAS on one worksheet, do you want to
return all occurrences to the cells on the summary sheet in the row
that specified the date sheet name and code value?

Are the codes (EAS, etc) always in a particular range or location on
the date worksheets? For example, can the search routine restrict
itself to a single column and/or a range of rows? Or does the entire
worksheet need to be searched.

Finally, are you worksheets named "DATE 02.05.09" or just "02.05.09"?

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Tue, 24 Mar 2009 05:57:53 -0700 (PDT), joecrabtree
wrote:

All,

I have a large number of worksheets. Each worksheet is named after a
date. For example 'DATE 02.05.09' What I would like to do is for all
the dates (Worksheets) in the workbook extract the relevant data from
the worksheet and place it into a summary sheet.

The specific data is defined by the summary sheet. For example if the
code EAS is entered, it would search for all the EAS's in the date
work sheets and return the individual values into the summary sheet.
As shown below:

The summary sheet would look like this.

DATE CODE VALUE
01.02.08 EAS 44
02.02.08 EAS 22
02.05.09 LIN 44

If anyone could give me some help it would be much appreciated.

Regards

Joseph Crabtree