insert date value into xls multiple sheets

I have an XLS with multiple sheets each sheet is named as a date entry (4-1-2010 and 6-1-2010 etc)
how do I create a column for each sheet and insert this date value (name of the sheet) to this column.

thanks