Hi there,
Can anyone point me in the right direction of how to receive a spreadsheet (Outlook) and automatically have the main spreadsheet update upon receiving that email?

Currently, we send reports out to about 15 vendors, they fill them out, and email it back to us. There are about 25 fields that they fill in and we copy/paste into Excel (I've thought of using Access).
I am confident that there is a way to automate this process. Can anyone point me in the right direction of where to start?

For what it is worth, I've already tried the Access email tool (where they fill out replies in the email and it autopopulates the Access database), but got a lot of complaints. The Excel spreadsheet is what vendors are comfortable with and have trained their employees on. Any inighst would be greatly appreciated!!

Thanks.