Macro to get data from individual files and add it into one common masterfile

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

Hi,

I'm also looking for something similar where I would like the data listed in different files consolidated one below the other to form one big list with all the data. I can then sort and extract the parts I want. The only way I have to do this at the moment is copying and pasting.

Can anybody please help with this?

Hello,
try this code :

for instruction plz open the attached and go through before run the macro.
for tab selection plz make changes to this line in script window "Sheets("DPEX-REX").Select" to Sheets("key here tab name of individual sheet tab name is there").select

from which row u want to copy adjust that also in script page (hint open script page and go step by step by presing the F8 function key)

if u hv any queries feel free to ask.

Thanks - Naveed.

@arlu1201
I would need to combine all the data from the individual files on one sheet in the new file (masterfile), in a table form.
I am attaching two print screens. The one shows how the individual file looks like and the other how the masterfile (the file in which all information is compiled from the individual files) looks like.

In blue and green you can see the cells that need to be transfered into the masterfile.
In the individual file, in lines 18 to say 28 (10 lines total), data points will be entered. I need to transfer those points into the masterfile from column K to P and lines 2 to 12 (10 lines total). In columns A to J, the information comes from the individual file in the blue cells. This info will need to be the same for all the total 10 lines.
Additionally, as the data in the individual files has also some formulas that calcualte different things, I want the macro to transfer in the masterfile the values only and not the formulas.
The macro should also run once every 5 days and when it is running, it should not pull again the info from the individual files already pulled say the week before. The files always stay in the same folder.

Thank you very much so far for the help :-)

Individual file 1.pngMasterfile.png

I did, but for the set-up I have in my file, it is somehow not working.

Any help please?