1. Moving this to 'Applications'
2. Assuming a recent version of Access/Excel, Import. This creates an internal table in Access. You can then generate whatever 'reports' you need. Or append to whatever tables you need.
3. Once you give up the Excel interface, you'll have to create an Access Form interface for people to enter the data. (Non-trivial)