Hi I have multiple sheets and in A1 of every sheet, there is the date. So Jan. will have 31 sheets.

Every sheet is basically a time sheet with people's name on it, in the range B2:Z70.

I have a summary sheet which counts the hours each person does across all sheets. I have a name range of the sheet names called "Sheets"

I want to count the names on each sheet and list the date next to it.

So on my summary sheet, if I have the name Frank, and if Frank works on 1/1/09, 1/10/09, 1/15/09,etc, the summary sheet will count the number of days Frank work in and list the date.

So it would look like:
Frank 1/1/09
1/10/09
1/15/09

Please can anyone help?

Thank You