Finding spreedsheets by name of it macro

[Szwadron]

Hello,

In attachment there is an empty file. I need to make two macros.

1) When I enter the file a widnow appear when I can write name of the spreedshit to go to. – already done that.
2) But I would also like to create another macro which I have no idea how to do. It would go for when I enter to this window name of the person I would like all the remaining spreesheets disappear.
Names are hidden as the initials as the last two digitis in the name of spreedsheet.

ES – Ewelina
MK – Maciej
AO – Ania O
DM – Dawid
RG – Renata
ET - Erkyk
AOL – Adam
MZ - Monika
AK – Ania K
AT – Amin
FM – Filip

Could you please help me with this? I cannot even come to think how to start writing this.

Thank you very much in advance.

[skywriter]

Maybe something like this.

You would just enter the initials, for instance AK and only that sheet will be visible.

Please Login or Register  to view this content.

[bakerman2]

You do not need an extra button on your Userform.
Userform code

Please Login or Register  to view this content.

Thisworkbook code

Please Login or Register  to view this content.