VBA to Fill Timesheet Data HELP

[Fe5ks]

The following table shows the date of the week and beneath each day is the hours that have been spent on a project, each row of numbers a new the project/job (not shown here). How can I get this into the table similarly setup to the right - with the same headings, using some sort of VBA functions or formula in excel.. Just wanting the dates to be all the monday hours first, then the tuesday hours and so on until friday. I have spent a lot of time trying to work it out and I cannot. Also, the days with zero hour I do not want to log. These hours change all the time.. and the amount of jobs can vary as well (therefore more rows).

Ideally I would like this to be almost automatic so the hours can be put in a button pressed and put into the format on the right.

Any advice welcome!

Please help!

Monday, 12 March 2018	Tuesday, 13 March 2018	Wednesday, 14 March 2018	Thursday, 15 March 2018	Friday, 16 March 2018
2	1	2	0	3.5		Date	JOB NO	PROJECT TITLE	ACTIVITY	HOURS
2	2	2	2.5	4
1	3	0	0	0
1	1.5	2.5	0	0
1.5	0	1	5	0

<tbody>
</tbody>

****** id="cke_pastebin" style="position: absolute; top: 120px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">

HOURS

<tbody>
</tbody>