For the Monday sheet, assuming B1 for first Monday
B1: =DATEVALUE("06-"&monthInput&"-2012")-WEEKDAY(DATEVALUE("06-"&monthInput&"-2012"),2)+1
C1: = IF(MONTH(B1)=MONTH(B1+7),MONTH(B1+7,"")
copy C1 to D1:F1
On Tuesday
B1: =Monday!B1+1
C1: =IF(Monday!C1<>"",Monday!C1,"")
copy C1 to D1:F1
Wed-Fri, ditto
Bookmarks