Ex: In B1 of Feb sheet. Copy across.
=IFERROR(DATEVALUE(Sheet12!$I$3&"-"&"02"&"-"&COLUMNS($A$1:A1)),"")
Change "02" to appropriate month for each sheet. You can make this part dynamic, but that would make formula volatile.
Since this section only needs to be set up once per sheet. There really isn't need to make it dynamic.