Need ideas for automating a complicated (many tasks) volunteer form/process. (Open for ideas from all)

Hi,

Every year our dog club has a specialty dog show that requires volunteers to perform many tasks. 3-4 years ago I created a spreadsheet to track the tasks (jobs) folks volunteered to do. Then I displayed the spreadsheet on a webpage with a form for folks to enter the job they could do by entering the cell number(s). This was very labor intensive - the form would email the info to me, I would update the spreadsheet and re-import it into the page and upload the page.

Here is a link to the page so you can see what I’m trying to describe;
http://www.oldenglishsheepdogclubofamerica.org/national/Volunteers/National_Specialty_Volunteers.php
In case the link doesn’t work I have attached a PDF of the webpage.

Where you see a name or cell number (C23) this is a task to be done.

This process has become very popular, I am asked to re-institute it every year, but it is terribly inefficient.

I would really like to automate this process where a volunteer could enter a task and the page would update to reflect this. But I have no idea how to set it up.

One thought I had was to create a series of dynamic dropdowns to get down to the specific job (Agility > Fast > Excellent > Gate Steward), but how could a volunteer apply for multiple positions?

I am open to any/all ideas.

Thanks,
Dennis