Hi BruceN,
Well done, I've managed to reproduce your technique and it produces a
summary of each day-sheet's D19 entry in combination with the date in
columns A and B. Very useful for people with lots of sheets with common
information in the same cell.

Ken Johnson