Work with multiple worksheets in PBI

If you are saying that you want all the tabs to show up together in Power BI, load them in Power Query then append them together as new query and disable the load on each of the individual files, this way when you are back in Power BI you have one appended table to work with.

Yes it will. Every time the source file gets updated and Power BI refreshes it runs through every step in Power Query - in your case it would involve the individual files coming in and then getting appended. When you turn off enable load in Power Query that just means that that individual query won't load in Power BI as a separate table, basically, you are hiding them. They will refresh and the Appended query will do it's thing 🙂 Managing query refresh - Power BI | Microsoft Learn