I need an expert of Google Sheets

We have a large fleet of pianos to maintain. The inventory is in a Google Sheet and we use a Form technicians fill to enter service items (tune, clean etc). We would need to link the “serial number” field to validate each entry by referencing the data to the pianos in the Sheet that contains inventory.Then we’ll need this data to be formatted so the school administration has easy access. We’ll have to talk to better explain.thank you!