Hello friends, hope all is well!
I learned a very cool trick! https://www.contextures.com/PowerPivot-Identical-Excel-Files.html
Now I can use PowerPivot to have mutli sheets/files with Identical Structure in one sheet/pivot (more than 5 million rows).
the problem is that the code is too slow...