Using Text From A Cell In Formula

For reference, I am making a spreadsheet for keeping track of college football statistics, team records, etc.

Each spreadsheet is named for a team (e.g. "Michigan", "Ohio St.") and lists that team's schedule. As part of my statistics, I am trying to compile the win-loss record of each team that team has played.

Generically, my spreadsheet looks like this:

Opp.'s W-L record
Game 1
Game 2
Game 3
Michigan
Ohio St.
Nebraska

In order to compile the W-L record, I would normally have to have a formula as in =SpreadsheetMichigan.J4 + SpreadsheetOhioSt.J4 + SpreadsheetNebraska.J4

This is quite a lengthy process as this formula is different for every team. I would like one generic formula to put on every team's page that would grab the text of each team's opponent for game 1, game 2, etc.

Basically, is there a formula that I can put within the formula to say

=Spreadsheet[ReturnTextFromA4].J4 + Spreadsheet[ReturnTextFromB4].J4 + Spreadsheet[ReturnTextFromC4].J4