Welcome to the forum.

You can consolidate all tabs using PowerQuery:

https://docs.microsoft.com/en-us/pow...urrentworkbook