Just a bit of clarification wrt the OP's ..
. Note that each day will have it's own
sheet (2-8) drawing its' data from the proper column.

The suggested set-up implicitly does away with the need to have multiple
sheets for each day, since the desired results for each/any day could be
easily retrieved via selecting the day from the DV in cell A1 (Sheet2). And
if necessary, the results in Sheet2 could also be copied and paste special
as values elsewhere.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----