Modiy and append daily excel file from Sharepoint folder

Hello,

I will appreciate help with the following - 

A daily file is added in a sharepoint folder.  I need to pick up this file every morning,

- take the date from the second row in the file or from the file name (which ever is easier) and add it as a column in todays data

- delete the first 2 rows

- append it to yesterday's file (which contains similar appended data from earlier days)

Need to do this every day.  What is the best way to do this.  Data volume is about 1000 rows each day.

Many Thanks!!