Scorecard excel

Hello, I worked with a friend of mine to create an excel document that pulls different files together and shows performance for different managers in my building. He was the excel brains I provided vision and direction. Well his brain is gone and i could use help making adjustments. Ive attached the file in the message and would love assistance