Local web form to excel spreadsheet

Ladies and gentlemen of Excel forum,

I have been tasked with the creation of a web form that will be hosted on our local network that automatically updates a shared workbook.

The web form is extremely simple no more than 7 input fields, however one input field does need to have a drop down box where the options can be altered via the target spreadsheet.

I envisage the target spreadsheet to have two worksheets, one for the content and the other to define the values.

I gladly welcome any suggestions.