I'm not completely sure what you are trying to do from your description. Can
you explain what you mean by "I need to collect certain days" and "bring the
associated value in columns B thru H"? Collect what, the values in B thru H?
Bring them where (I know the report sheet, but where on the report sheet)?
Also, how are the sheets you are collecting the information from named? Is a
VB coded solution acceptable?

--
Rick (MVP - Excel)


"Gary" wrote in message
...
I have several sheets that I need to collect data from. Coloumb A has
dates
Sunday thru Saturday, formated as: Tuesday, August 25, 2009
There
are twelve sheets like this....one for each month. On the "Report" sheet,
I
need to collect certain 'days of the week' which are Tuesday and
Thursdays
only (this may change later) and use the values associated with those
days.
The cells that each day is in will change from month to month and year to
year. Is it possible to tell Excell to 'locate' a certain day in a
particular coloumb and bring the associated values in coloumbs B thru H?

I don't always find my way to this area, would you mind if you contact me
at: ?