Vba macro code for generating years along the side of days and also by removing the months

Respected Sir / Madam,
Please do help me with the VBA macros code for generating the output given in the attached excel sheet.

I need the output to be like this. that is,
1) the months must be removed and
2) in the left side, i must get the years till its end. and finally,
3) the empty cells has to be removed. (since in few months we don’t have 31 days and i had yellowed the part for your easy understanding).

pls generate code to give output like this.. please help me... I have done manually and I have attached the excel sheet for your kind reference and perusal. Like this I have to do for 65 files…

please oblige and do the needful..
Thanks & Regards,
Dharani.


PS.,
hope I am not doing any mistake in this post...