If I understand you correctly, this should get you started in the right
direction:

=INDIRECT(TEXT(A5,"dddd") & "!c10")

This assumes your date is in column A and is an actual date, and in C10 of
worksheets Monday - Friday is where the total you want to retrieve is.
Oh, Monday Totals. Try this instead:

=INDIRECT("'" & TEXT(A5,"dddd") & " Totals'!c10")

--
Kevin Vaughn


"JennLee" wrote:

I have a workbook containing a separate worksheet for each day of the week on
which to post activity for specific days/dates. Worksheets are named Monday
Totals, Tuesday Totals, etc. I have a cell on each worksheet that contains
the date for that particular Monday, Tuesday, etc. Then I created another
worksheet at the end I named WEEKLY TOTALS that I needed to give an overview
of the week in one area but still by date. So how do I do an auto thing in
my WEEKLY TOTAL sheet that will pull the date from the Monday Totals
worksheet into the correct cell in my WEEKLY TOTAL wk sheet and the date from
the Tuesday Totals ws into the correct cell in the WEEKLY TOTAL wk sheet,
etc? Clear as mud?
Thanks in advance for any assistance - I'm actually almost delirious from
stressing over a solution. Need something kinda ASAP!
--
Jennifer Lee
IS Coordinator/App Support