Can someone assist me how to extract the following data from excel

in general we can do it with grouping the data:

About the output. It would be helpfully if you can specified it more in detail e.g. for each manager a worksheet…