Report Of Employees leaves

[moon15523]

Hi team,
As am handling employee leaves and attendance record amfacing some issue on gathering the hole year data so am looking on some help inthe sheet I attach you will find all the staff and the dates that they been in annualleave ( AL ) , Sick leave ( SL ) ,Official duty ( OD ).
the official working hours is 8 every day . and employee eligiblefor 30 calendar day for sick leave and 35 working day for annual leave.
I required macro to rearrange the information in the table andput it into the reportformat I select any staff I hope any one can help.

[moon15523]

please help me on this