Do some Excel Work

I need excel data to be analyzed and spit out results into a template :) I have attached an excel doc that I use to display competition results. In the excel sheet you will see two tabs that I used as a sample. I want all the subsequent tabs with a template on them to be filled in just like the sample is. The tabs named "Excel Data _" are the tabs were we will "paste" the information our website gives us. We want to use this data for each competition (Highline, Highline Import, European, Japanese, and American) to gather the information from and then insert that data into the templates I provided. Penalties will not be gathered from this data. All the data here can be grabbed from the excel sheet without analyzing with the EXCEPTION of the Store Name Scores. The Store Name scores come from the data like this: store name score = sum of all the advisor's overall ranks. I need the store name score to be inserted in the template for that store and then I need all the stores in that competition to be ranked from first to last (smallest score being the #1). Don't worry about the penalties columns.