Create a querytable in each worksheet, linkedto the respective csv-files,
When opening the file all links will be updated.
Copy the new data to a separate integration worksheet. There will reside the databse with all dtat.