Oh dear - dates are crucial in my consolidated worksheet. Never mind, I will have to consolidate them manually.

Many thanks for all your help though - now I understand how it works, hopefully I will be able to make use of this feature for another task.