You could load each of the sheets into Power Query providing that they are all arranged exactly the same. Once in PQ, you could append each to the other.

Here is a tutorial

https://www.powerquery.training/port...ta-from-files/