Hi @Chan,
Thanks for the update.
There is no 'tab' available in PowerApps that would act as the Sheet tab in Excel.
But we could workaround this by using the Visible property.
There is a thread talking about it:
Control conditional visibility
The full scenario should be as below:
1. Pre-defined buttons for different Gallery to hold the corresponding table, with the related variable (UpdateContext({Variable1,true}) ) configured in the OnSelect property of the Button control,
2. Make sure the Button controls to only display one Gallery,
3. Variable name configured to the Gallery Visible property, use UpdateContext({VariableName:true}) for Button to show the Gallery, use UpdateContext({VariableName:false}) for Button to hide the Gallery,
See if this would meet your requirements.
Regards,
Michael