Thanks for the information about the Forum!
So what I need to do is that where I work, we have tensile tests. I will get three different data from one test, meaning that on chart I would have three lines. The test's data will be saved in a specific folder as .xlsx file containing only one sheet. The problem which I haven't solved yet is that every time I use the macro, it copies everything from that folder. Instead I need that only the newest .xlsx files would be copied to my wb while keeping the older ones in the wb at the same time.
Also I need that every time I copy a sheet into my wb with the data, a chart should be made on the first sheet (which is the main or parent one).
I will attach a file where you can see the main wb where all previous files were merged.
You should see charts on the 1st sheet "Munka1" where you can see the 3 lines of each chart containing 3 consecutive measurements.
Now at this point I have to change the sheet names manually to plot a new chart. It should be automated if it's possible, like I don't know every time 3 new sheet is being created, the code should plot those sheet's data into 1 chart shown on the 1st Sheet.