I have several excel tables that are completed in the factory by different people, with different data in it (in the picture below (work file)). We have dozens or maybe more of these work files per day. Then, I have to centralize them in another excel table (table 1) manually. Is there a vba code that can help me add these data in the table 1 automatically? Please note that the work file keeps changing, so the data in the table has to stay saved for the next work file the data to auto-save in the next row of the table 1.

For now, I managed to do the linking between the files, but when I introduce the next work file, it automatically changing the data from the table and I don't need that. I need all my data to stay saved and be added on the next row.