Puzzled on Best Way to Model Excel data

Hi Folks,

Thanks in advance for help.

I have the following extract from Workday that I'm loading into Power BI from an Excel file to help do merit planning.

Each Manager will get their own Excel extract to enter the proposed salary increase the worker is getting. All fields will be locked from edit except the Prosposed Increase column. For example, Fred Jones would receive the following Excel template:

Daphne would receive this Excel template:

I would be keeping each individual managers template in a Shared folder and then only sharing the individual files with that manager through OneDrive. So for example, Fred would get a file named Fred Jones with his two workers on it. He would populate the proposed increase and then close the file once he's done. 

I then want Power BI to pick it up and populate it in POwer BI on refresh like this (This assumes Daphne hasn't done hers yet):

I have to do this for 60 managers. The only way I can figure out how to do this is to APPEND 60 different Excel tables on top of each other in order to make this work. In my real data set, there are 5 fields they will need to fill out, not 1. 

Is that the only way I can do it or is there another way to make this easier? 

Many thanks for the help!!!