Capturing data from multiple people without using Excel:
This is a single most useful feature of SharePoint. No programming. Just create a list and get started. Much better than using Excel. Start using it NOW!
SharePoint 2013 update: Datasheet view is now called Quick Edit. It does NOT require Access to be loaded and it works on all browsers.