I work for a 125 member Fire Department with five Stations. We create accountability rosters of the members on the apparatus at the beginning of each shift. I would like to use an Excel based roster with Engines, aerials, and cars with roster drop down boxes for each company where the officers would log in and create each days roster preferably on a document based here. Right now we have separate copies of each station roster created locally at the stations and then faxed back and forth, this is tedious for the officers and i would like them to be able to click on a link to a page here with one Excel document that they could edit at the beginning of each shift. Thanks for any help that can be provided. 

Creating a drop down list in excel is fairly easy to do.  There are two ways to do this depending on the version of excel you are running.  Office Online http://microsoft.com/office has detailed instructions.

For Office 2003 and prior versions:  http://office.microsoft.com/search/redir.aspx?assetid=HP052022151033&QueryID=qiEDxwRsX0&respos=4&rt=2&pid=CH010036961033

For Office 2007: http://office.microsoft.com/search/redir.aspx?assetid=HP100725991033&QueryID=qiEDxwRsX0&respos=5&rt=2&pid=CH100648501033