Task scheduler and python program

I received automatically Four file csv per day in my local network

And I need to execute a program ( you must develop the program) in local automatically when the four files are in the local network to transform the four file to one table

The program is describe in the excel file.

I need a program develop in python. An you must transform the program in .exe ( Can you show me how to do this to transform a program python to .exe)

You must show me how I configure the task scheduler to execute the program automatically

I will send you an excel file with all transformations to do on the 3 files to obtain one table


The file contains:

The green sheet : there are the csv files .there are the files that received automatically. In green the raw data. in the right I make little transformation.


The yellow sheets : there are table of parameters. Those sheets dont change. Theses sheet are used to obtain the final table


The blue sheet : is the final table that I need to obtain in the end of program some columns are obtain whith a little function vba that you must reproduce in python)



In the program to recognize the four files CSV. you must use the name of the columns . The names of the columns are in the first row of the csv