List of CSV files + scraping data out of each hyperlink

Hello,
I want to ask for help with following...

I have bunch of *.csv files (semicolon separated) which contains data from automatical measurements. Trying to find the way how to quickly analyze them at once and to scrap out specific values. Content of each one is dependent on results (not always the same number of lines). Files names reflects the results by suffix (*_P.csv, *_E.csv, *_F.csv, so might be helpful to start with this:

Step 1
automatically create list of CSV files in *.xls or *.xlsm: Filenames (written in column A), date/time of each files (written in column B) and hyperlink with file path(written in column C).

-possibility to open various folders and not to use only one path would be best
-if nothing, then will have list which I can sort and possibly open each csv file manually and write some comments to it


Step 2
automatically open each file from the list of hyperlinks and search there:

files with suffix *_F.csv -> search in all cells in column K -> if there is written "1", then copy from the same line cells B, C, D, E, L, M, N into columns D, E, F, G, H, I, J in table from the Step 1.

-there might be more "1" results in each *.csv file, so if more than one, then have to be written to other columns (K, L, M....)
- Searching should start from the line nr. 7 and stop when reach the line nr. 211.
-Cells B, C, D, E contain text
-Cells L, M, N contains numbers and should be written like numbers

files with suffix *_E.csv -> search all cells in column B -> If there is is one which contains inside the text "the errorcode", than copy this whole cell into table from Step 1 (column D)

- there might be only one result for each *.csv file
- searching might stops when reached line nr. 270

files with suffix *_P.csv -> do nothing (those one doesnt contains errors or failures, so no information have to be scraped out)


Many thanks

Here is link with data example: ufile.io/da3qd