Create an Index in Excel VBA? Match company data to corresponding ticker on different sheet.

I need help with Excel VBA. I want to automatically sum vertical data for a company and place sum values on a different sheet, with the corresponding ticker.

I have a Key for the company and corresponding tickers. See screenshot.

The raw data structure looks like this:

And I need help with EXCEL VBA code to transfer this data, to corresponding Ticker on another sheet:

Any explanation regarding the intuiton and mechanics behind how the code works is very much appreciated. I really want to understand this stuff.

Thanks!

FILE HOME INSERT PAGE LAYOUT FORMULAS DA &Cut Calibri Paste Format Painter BIW-IE-2.A Clipboard Font A1 Agilent Technologies 1 AA 2 AAC Alcoa Corp 3 AAN Aac Holdings Inc 4 AAP Aaron's Inc 5 AAT Advance Auto Parts Inc 6 AAV American Assets Trust 7 AB 8 ABB Alliancebernstein Holding LP 9 ABBV Abb Ltd 10 ABC Abbvie Inc 11 ABEV Amerisourcebergen Corp 12 ABG Ambev S.A 13 ABM Asbury Automotive Group Inc 14 ABR ABM Industries Incorporated 15 ABR-A Arbor Realty Trust 16 ABR-B Arbor Realty Trust Inc 17 ABR-C Arbor Realty Trust Inc 18 ABRN Arbor Realty Trust 19 ABT Arbor Realty Trust 7.375% Senior Advantage Oil & Gas Ltd FILE HOME INSERT PAGE LAYOUT FORMULAS DA &Cut Calibri Paste Format Painter BIW-IE-2.A Clipboard Font A1 Agilent Technologies 1 AA 2 AAC Alcoa Corp 3 AAN Aac Holdings Inc 4 AAP Aaron's Inc 5 AAT Advance Auto Parts Inc 6 AAV American Assets Trust 7 AB 8 ABB Alliancebernstein Holding LP 9 ABBV Abb Ltd 10 ABC Abbvie Inc 11 ABEV Amerisourcebergen Corp 12 ABG Ambev S.A 13 ABM Asbury Automotive Group Inc 14 ABR ABM Industries Incorporated 15 ABR-A Arbor Realty Trust 16 ABR-B Arbor Realty Trust Inc 17 ABR-C Arbor Realty Trust Inc 18 ABRN Arbor Realty Trust 19 ABT Arbor Realty Trust 7.375% Senior Advantage Oil & Gas Ltd