Excel Based Polling Solution

hi Experts, i'm trying to pull together an excel based solution (though I'm open to other software) that will help me gather information at a polling booth for an upcoming event.

We will have 4 to 6 laptops set up on which I'd like to have a spreadsheet, or an infoPath form, open to collect customer feedback - it will be a mix of multiple choice questions, ranking of options, and open feedback.  I'd like the user to complete the form and click a "submit" button.  That button would send the data to a central spreadsheet stored on SharePoint (or a SharePoint List) which would then update some charts in real-time.  The charts will be displayed on a screen behind the booth so that the customers can instantly see impact of their feedback.

I'm suggesting Excel because I'm comfortable with VBA and SharePoint, but as I mentioned, if there is something else out there - more than happy to entertain better suggestions.