How to sort data with macro or VBA

Dear All,

I am getting a file on daily basis with 10.000 row and 20 different column and everymorning i have to sort the date using the filter option on excel, cos i dont need all the rows and columns on the file. is there any way i can set up macro or VBA that it can select the data and the category of my choice .
I attached a sample and marked columns and rows with yellow colour which the data i need from this file

Could anyone help, I really need this to make my life easier