Create a column in a sheet called Password. Enter the password in that column.
In your users sheet, create a column called Password Entry.
Have a text entry on the tab that gets users to enter the password — write this to the Password Entry column.
Filter visibility of components for when the Password Entry equals (or doesn’t equal) the Password.