In [ ]:
d = []
for filepath in coach_xlsx_paths:
    # use pd.ExcelFile instead of pd.read_excel in order to use variable sheetnames
    with pd.ExcelFile(filepath) as xl:
        for sheet in list(set(xl.sheet_names) & set(sheet_months)):
            # Returns ordered dict
            heatmap = pd.read_excel(xl, header=[2,3],
                                    sheet_name=sheet,
                                    usecols=14, index_col=None)