Google Sheets Pupil Lookup Script

I have a sizeable Google Sheet containing pupils' names and their corresponding grades, each in a single row. I need a script that enables a user to input a unique pupil ID to look up their information, displaying only that specific row. The script should also include the following functionalities: - Show a direct link to the data in the selected row on another sheet, namely 'mywork sheet'. Ideal Skills and Experience: - Proficiency in Google Apps Script. - In-depth understanding of Google Sheets functionalities. - Experience in creating interactive scripts for Google Sheets. - Ability to build clear user interface for data lookup. - Familiarity with data linking across sheets. And in my words below I have a list of names on a Google sheet. - Pupils and their grades in each row. Currently I share this in view mode but they can all see each other's row of grades. I want to hide this sheet, and share another sheet “My Work” where they can enter their number and it shows only this row of grades. - not all rows. See the link and the sheet called Y11 grades - see copy below The names appear in column C - I will hide this column Their ID is in col B I need a new sheet which shows the same headings. Rows - 1 - 7 - with a link to my main sheet. This must change when I change my main sheet to always be the same. In this new “My Work” sheet they should enter a number and their row is shown. Can you update my version below to do this? BUT I would want the solution so that I could understand it and apply to my other gradebooks. If you can think of any other/better way to do this then suggest it. But I only want to maintain one copy that I can see all names and the students only see their row! [login to view URL]