Summarising data.

NBVC hows things....

See attached.

Essentially all I want is the summary sheet to show the data in where columns S, W, AA, AE, AI, AM have a 'red figure' (number above 0). Where this is the case I want the data in all the columns on the summary sheet to be filled with the data in each day's record sheet. (This also needs to work as a drop down!!!)

Many thanks as always!