importing data from external software into excel

hello,

I need to create a macro that would copy across the data from an external software, see screenshot, into an excel spreadsheet.
The idea is that I am getting tons of files in that software ( which is based on SQL server if it can help) , and i need to copy across the column "name" , date, KP start & end ... and it would be so usefull to have an automatism.

does anyone know where to start?
many thanks!