Hi MIMF,
There are myriad ways to do this, including creating a form directly in Access and merging the results of all the access tables that are returned with the forms. There are probably forums like this one elsewhere on the 'net where you could get specific help with this approach.
This can also be done quite easily in Excel, having users enter the data into a spreadsheet, and processing all the returned spreadsheets in Excel VBA to merge them into a single Excel spreadsheet before importing the results to Access, or using Access VBA to just import the results directly into Access tables. This is pretty easy, and if you should decide to go this way you could get a lot of help here at MrExcel.com.
Another possibility, and one I favor (even thought my first love is Excel), is to use Word. Word has a pretty good forms capability (check into Word "Form Fields"), and it is quite easy from Access VBA to read a whole folder full of Word forms, reading the values from all the form fields and populating an Access table with them.
I realize that my answer is very general, but hope is helps.