Please help, as this seemingly simple but annoying issue is driving me nuts!

I have 4 colums of meterological data (A-D), and starting in cell D1 i have days in sequential number (i.e. day 1, 2,3.....365,366,367....etc) - 5 years worth!
I need to convert these to hours (numbering 1,2,3....24,25,26 etc), for which their will be ~43000 hours for the 5 years.

I figured it best to select the first line of data, insert 23 lines below, and copy the 4 colums of data in the first line to fill the inserted 23 lines, then move onto the next line of data and repeat until no more data is present below. An example of the data is found below:

DATA: Days value 1 value 2
2007 1 23.5 2.74
2007 2 34.0 2.83
2007 3 97.1 2.71
2007 4 62.2 2.99
2007 5 74.0 2.56

I need a macro written to help me with this issue, as my VBA sucks and my written macros haven't work out.
If i can get some help on this i promise to relearn VBA again (properly this time).
Ta for anyones help