Job categorisation model / database in Excel

I need someone who is very good at excel in terms of 1) formula development 2) explanation of how the excel has been developed 3) high quality presentation to build me an excel model.

I have a set of tasks that someone in any role in an organisation would do and I have ranked each task to determine the likely workplace setting for this task based upon one of 4 work settings. So "Learning from others" has a ranking of 4) - Flexible (more office based) through to 1) Home based. There are 22 work tasks in total.

I now need to develop a model which takes one role at a time (4,500 in total) and determines which setting the specific role will be in. So I would like to have a Data base which does the following

Roles:
- A form which I can input data into and once complete, I can hit a button, it clears and I can input new data
- A cell to input the role title
- A cell to input directorate
- A cell to input line manager
- Area to input the role location
- List all tasks and provide a column to rank them from 1-22 in terms of importance of the task to that role
- A column next to each task and ranking that allows me to enter a "Low" "Medium" or "High" frequency by which tasks is undertaken.

The model then determines, from all the information provided in this form, plus the overall categorisation / ranking of the tasks on the previous page, which one of 4 categories this role falls into.

The form, when you hit a button will clear, all the data from this form will go onto another page and I can then enter another job role. I want to be able to go to the data page and delete a line if I need to start that one again

I would also like an analysis page from the data provided which I can use as a report format giving me key to executive level stakeholders. Information such as categories and locations of these categories (based upon the persons job role) break down of the categories by directorate. The programme is called "Workforce Categorisation" which should be displayed on the report along with my name and the date.

I want this to be smart and professional, it needs a cover page, really good, clear and concise analysis and, importantly, I must be able to (If people wish to see it cut another way) be able to change the overall ranking of tasks across roles if required and that then feed through to all of the data. (The page I have included in the excel and summarised above)

Looking for a quick turn around please. I have provided a summary excel page of the tasks