Update assignments in template based on sheet

How can I assign ownership to tasks based on contacts in a sheet? For example - I have a list of contacts that define the owner of each area for every project. As I am creating a new project from a template, I would like to lookup the owners for the tasks based on the information in the sheet.

Example - project below would be updated based on the master resource sheet.