Unable to auto-update Primary Worksheet Manager in WFC Plan

We've HR Extraction Date to the plan as 31-Mar-2025.

When a manager A gets terminated on 31-Mar and new manager B is assigned effective from 1-Apr-2025.

As the refresh process runs and refers to data with effective date as 31-Mar, the primary worksheet manager still reflects as Manager A, but we would prefer get this updated to Manager B.

Is there any possibility or if we need to update it manually, how do we identify and bulk update them?

Regards,

Vaitheghi