data.py

import openpyxl

wb = openpyxl.load_workbook("data.xlsx")
ws_1 = wb["Sheet1"]
ws_2 = wb["Sheet2"]

for column_no in range(2, ws_1.max_column + 1):
    cell = ws_1.cell(2, column_no)
    if cell.value == ws_2['B2'].value:
        for i in range(1, ws_1.max_row + 1):
            ws_1.cell(2 + i, column_no).value = ws_2[f'B{2+ i}'].value

wb.save('data.xlsx')