I'm putting together a form on Excel for compiling financial information from
13 project partners. I want to make it as simple as possible, so ideally
want all the information that flows directly from who's filling in the form
to be inserted automatically. Is this possible?
i.e. when they select their name from a dropdown list, the fields relating
to address, country, allocated budget, etc are automatically filled in.

Thanks for any help.