Showing hidden tabs with a button, then, auto hides when de-selected

Good day to you!

First of all, I hope everyone is staying safe amidst all the turmoil and pandemic happening in our blue planet. I am basically a newbie on VBA but, I understand the concept of capabilities of this feature as to what it can bring to our spreadsheets. I would like to ask for help regarding a spreadsheet of mine. On sheet 1 there are three buttons, and the goal is for those buttons to show hidden tabs (That are hidden) corresponding to their button name. If I click "Show Tab 1" button, it should show the hidden tab "Tab 1" and when de-selected, I would like for that tab to auto hide himself. I am attaching the sample here.

Thank you for your help in advance, and again, stay safe!

Maybe something like this ?

Put the below code in Sheet1 module:

Please Login or Register  to view this content.

And

Put the below code in Sheet Tab 1 module:

Please Login or Register  to view this content.

Put the below code in Sheet Tab 2 module:

Please Login or Register  to view this content.

Put the below code in Sheet Tab 3 module:

Please Login or Register  to view this content.