Can I speed up this process, not a problem for a couple of people, but if there is 150+ any help is welcome

As you can see in the pictures to get a result on the sheet 2 had to:

1. copy from sheet 1 paste special into new sheet (marked Transpose option)
2. select all cell with data and make degrees to 0
3. double center cells, modify cell to bold, font size etc...
4.repeat all for second person etc etc..

Is there any VBA or Macro to have this prosses automatically as I write data from one sheet to get a result on the sheet 2

Here is dropbox with an example workbook link...

https://www.dropbox.com/s/ka2qvilazc...test.xlsx?dl=0