Vba To Sort Report In Excel File From PDF

On the intranet we have some reports in PDF file when I open it in excel i get this kind of results: from pdf opened in excel.xlsx

Now I want to sort values in that way to operate, calculate and to be more organized.

Let me explain what does mean each parts of values in report from intranet..

Red text in A column = type of event
in C column = start of event
in D column = end of event
in E column = duration of event
in F column = control number
Blue text in H column = material name

Green text in B column -> if in A column text is green and write "Komentar:" then in B Column is comment typed by employees, If in A column text is green and write "Pri dogodku:" then in B column is type of event where was comment above writen if in A column text is green and write "Vnesel:" then in B column is name of employees wich write comment

The name of line where that event has been is in D column if in A column is date with black text (hope u understand see in attachment)

So I want to paste this report to one sheet and have in other sheet report in order A column is DATE, B LINE, C TYPE OF EVENT, D EMPLOYEES WHO WRITE COMMENT, F COMMENT, G DURATION OF EVENT, H CONTROL NUMBER, I MATERIAL NAME

In each row is details of event so I could see how many event I have, which kind of, duration etc