Count specific cells in multiple excel files and report them in a separate file.

Our work schedule is in an excel sheet saved on a server. Each worker is in a row (name in first column) where for every day there is a color code depending on the worker’s shift. I want to count all the same colors in a row of each worker and report it into another excel file. There are two teams (cadre and intern) and therefore always two planning. I added an example of a planning sheet (planning example.xls which will be saved on the server) and an example of the sum sheet (sum.xls which will be on my local disk). See attached files for details and examples.