Excel User form saved to Master Scorecard saved in OneDrive

Good Morning,

I always seem to be asking for help, but trust me I am also learning alot when people reply with solutions. I try to only ask for help on new tasks I am trying to accomplish (well not always, but I give it an honest shot lol)

Today's thing:

I want to make an Agent Scorecard that Supervisors fill out and will give an overall score (excluding NA's). Each question has a drop-down menu of scores (100-75-50-25-0-NA). Part of the scorecard the Supervisor has to use a drop down which will show his/her name. When they select their name, only the agents that report to them will be options on the Agents name cell (not sure how to do this.).

With the scorecard complete, I'd like to have them press a button which would copy,paste transpose the data from the form into a master scorecard that is saved on OneDrive and then will save the Agent scorecard on their local computer with the name - "Agentsname_date" take the info from the form.

I have attached 1 document Tab 1 - Input Scorecard - This is what would be saved on Supervisors computer. This also has my thoughts on how it should be laid out. In tab 2 - Master scorecard - this is what I would like it to look like whereas the data from the Input scorecard would transposed into the next row at the bottom of the table.

If this is possible, this then allows me to make some pivot tables on the agents activity.

First of all - is this even possible to do?

As Always, I appreciate any help

NorthernWarrior