Further to my earlier post i am trying to create a list automatically on a
worksheet drawn from other worksheets.

I have 12 monthly worksheets and a summary page

I want to get Excell to look in a column F on each month and if it has a
date in it pull the info from col A & B to create a liston the summary sheet