thats not what i meant.
you can keep the original sheets as you like to work with and to look at, but additionally automatically create (via appsscript) a a data source out of it (into an new sheet).
It doesn’t matter how many original spreadsheets there are and how many sheets each of them has, and you won’t need to even look at it 
If you insist to keep the original format of your sheets, thats the best way in my opinion.