How can I update row data when the date column changes?

[VIETGATAN]

I have a excel sheet with a date column and data columns for work a, b, c, and d
My goal is to update data only on working days
I use a date sheet and the WORKDAY.INTL and SEQUENCE formulas to exclude weekends and holidays (holidays can be manually updated in the holidays column)

After removing weekends and holidays, I generate a date list in the CPP sheet. When I update new holidays in the holidays column, the new holiday dates are removed from the date list in the CPP sheet, but the Work A, B, C, and D data do not update.

How can I make the date list change and Work A, B, C, and D data update automatically?

 

[kvsrinivasamurthy]

How and where from data is updated for columns A,B,C and D.

 

[VIETGATAN]

This work (a, b, c, d) is for staff to input manually. When I update the holiday date, in the CPP sheet the row after the holiday date should be removed. For now, only the holiday date should be removed