I'm trying to work out a formula to extract dates from a spread sheet and
show them on a summery sheet.

Ive set up a sheet that has 12 tabs one for each month, in each sheet there
are names down the side (A4 to A98) and the dates along the top (D4 to AH4).
I then enter a "H" in the appropiate cell when they take holidays.
What i would like if possible is to have a formula or macro that colates all
the dates when holidays are taken and displays in the summery sheet similar
to below

Holidays Taken
1 2 3 4 5 6 7
J Bloggs 02-Jan 05-May 06-Jul 08-Aug 09-Sep
Can anyone help please