data_sheet = wb['Sheet1'] # or whatever the name of your data sheet is mapping_sheet = wb['Sheet2'] # or whatever the name of your mapping sheet is for row in range(2, mapping_sheet.max_row + 1): host ...