Company Workflow Systems Builder

We are looking for someone that is an expert on Excell sheets that can create macro and automated actions in Excell. Furthermore we need the person to be an expert at google forms as we wont to move from jotforms to google forms.
That person sole duty is to think and create automated workflow in excel and forms and teach the team how to use them.
PLEASE DO NOT APPLY IF YOU CANNOT DO TEHSE THINGS.
Along with resume please submit this two tasks for us to know you are capable
1- Create Sheet call LEAD FORMS with column CLIENT NAME- EMAIL - PHONE NUMBER - SOURCE - AGENT
We want that each time we select a different agent, the whole line with this client info gets copied to a different sheet belonging to this particular agent.
2- Create a google form as an invoice that my assistant can fill out and assign it to a client to approve, it needs to have calculations such as quantity multiply by cost.