teams_by_name = {
    'Eastern Unit': eastern_unit
    'Eastern Local Team': eastern_local_teams
    'Mid West Unit': mid_west_unit
    'Mid West Local Team': mid_west_local_teams
    'North East Unit': north_east_unit
    'North East Local Team': north_east_local_teams
    'North West Unit': north_west_unit
    'North West Local Team': north_west_local_teams
    'South East Unit': south_east_unit
    'South East Local Team': south_east_local_unit
    'South West Unit': south_west_unit
    'South West Local Team': south_west_local_teams
    'West Central Mid Unit': west_central_midlands_unit
    'West Central Mid Local Team': west_central_midlands_local_teams
}

units_and_local_workbook = load_workbook(filename='teams.xlsx')
for sheets in units_and_local_workbook:
    unit_sheet = units_and_local_workbook.get_sheet_by_name(sheets.title)
    for value in unit_sheet.iter_rows(min_row=3, min_col=1, max_col=1, values_only=True):
        string_out = str(value)
        unit_number = re.findall(r'\d+', string_out)
        if unit_sheet.title in teams_by_name:
            teams_by_name[unit_sheet.title].append(int(unit_number[0]))
        else:
            raise Exception("Unexpected team name: " + unit_sheet.title)