from openpyxl import load_workbook wb2 = load_workbook('test.xlsx') ws4 = wb2["New Title"]
You should check if your sheet in sheet names wb.sheetnames
print(wb2.sheetnames) ['Sheet2', 'New Title', 'Sheet1']
References
https://stackoverflow.com/questions/36814050/openpyxl-get-sheet-by-name