Bidirectional Google Sheets? – Exchange of web applications

I want to create a spreadsheet in Google Sheets with an editable and friendly front-end interface and an interface with an arbitrary number of rows containing the data to display. There should be a drop-down list on the front-end allowing me to select which line (or a new row) in the back-end is displayed in the rest of the front-end fields; and all changes on the front-end must be saved on the back-end.

I know that vlookup can be used to display backend data on the front end, but I'm pretty sure it will not send any changes to the backend. Is there a way to do this using Google Sheets, alone or with other Google Web applications?