Hello everyone,

I do have multiple files in a folder, which are exactly identical but include data from different days. That means that each file has lots of lines of data, all representing one day. For example I have files:
"Data Day 1", "Data Day 2" etc.
What I need to do is create a masterfile, which will get the daily data from all daily files and put it in this masterfile, so that I end up having one file with all data of all days. For example I want to create a file "Masterfile Data" in which daily the new data of the new daily files is entered automatically.

Can somebody tell me how I can create a macro, that will update the masterfile everytime a new daily file has been created and saved?

Thank you