Excel 2007 : Create a form to enter data into workbook

I have created a work book that covers all the information that I need and it is truly a beatiful thing but the guys filling it in are having difficulty with the new format. I am keen to get advice on how to create a form that will fill in the data required on other worksheets.
Essentially the work book tracks aircraft utilisation over time. We have a number of aircraft and I would like a single data entry point to distribute data as appropriate. eg I enter data for one aircraft's flight and then at the same point I enter the data for a second aircraft's flight this data is then separated and placed in the correct list as in the attached example spreadsheet.
The data entry must be as simple as possible as the guys filling it in have limited time to fill in the data and limited understanding in order to correct errors.