Yes this is doable. You need to look into InfoPath (http://office.microsoft.com/en-us/infopath/default.aspx) It will allow you to create forms and also keep track of data entered through the forms. Here's a demo: InfoPath Demo

You might be able to do it in excel, but it would require programming and would most likely cost more to do than to buy InfoPath.