Google Sheets - Dynamically Combine Sheets

This tutorial shows a technique to dynamically combine multiple sheets that are contained in the same spreadsheet not using the QUERY() function. I am sharing the completed spreadsheet model so you can make a copy for yourself

Please like and comment if you have any questions.

Dynamically Combine Sheets Spreadsheet
https://docs.google.com/spreadsheets/d/1xvW2OGhgP4RkCNdwqJO-5OfiuB3PNf3l8eryt0HmL2A/edit#gid=0

Named Function Tutorial (includes link to Named Function Library)
https://rumble.com/v25qm9k-introduction-to-google-sheets-named-functions.html