Customer Password Migration from Site A to Site B

I have two Magento sites:

Site A : has a set of customers.

Site B is a new Magento installation, and I need to copy the missing customers from Site A into Site B.

Magento Version is the same 2.4.5.

I want the following to happen:

Copy all the customers who are missing in Site B from Site A, including all necessary customer information such as email, password hash, and other attributes.

Ensure that when a customer from Site A logs in on Site B using the same email and password, the login process works seamlessly.

I have already tried importing the customers by copying data directly into the customer_entity table, but I’m facing issues with the password hash and login functionality. When I use the same hashed password from Site A in Site B, the login fails, and I have to reset the password for the customer manually for it to work.

How can I ensure that the customer data, including the password hash, is correctly migrated, and the customer can log in seamlessly on Site B with the same credentials from Site A?