If you want than the user A access only to the sheet "A", then you can rename the sheets with the user names and use it to access so, user A will access to sheet A, user B to sheet B....If you want a complete login procedure may be this can help you:
Register/Login with Google Sheets - Tutorials and Guides - MIT App Inventor Community