Macro For Sheet One To Fill Sheet Two

I have this schedule (sample below) and what I need is the second sheet to look like this. I am trying to make a macro that will auto fill in the 2nd sheet. I was hopeing the macro could be put on the main schedule so that you clicked on the date at the top of the schedule it would make the second sheet which follows. It can then be printed and posted. Ok this is where it sunk my boat. Take the letters before the (,) and put on sheet two designation line and column matching. Name obviously goes under name. Now for the trick if possible, under day of the mounth (12/30) fill out the rest of the sheet. Take information out of sheet 1 and place them Starting with lines 4 thru 9 in the column designating night crew. Lines 10 through 24 disegnated under day cloumn and then last 6 for the evening column. (Another trick is if any of the names work a different shift I. E. shifts are 6 to 1 days, 2 to 11 is evening and then 12 is night. Anything in column other than a number or the word noon should follow thier shift designation as described above. D=day off and blanks to stay blank. Now for the dream, can sheet be made to allow for additional names on any of the shifts without messing up the whole thing.

Deadline for next schedule 11/19/2012
12/30
12/31
1/1
1/2
1/3
1/4

[code]....

I know I requested a macro but any way that gets it done will work.