Excel Records Master Consolidation

I have a set of Excel spreadsheets that collectively hold about 52,638 rows. Sl No. / Certificate No.: Unique identifier/number for the issued Scheduled Caste certificate. Issue Date: The date the certificate was issued (ranging from January 2011 to May 2026). Applicant Name: Full name of the certificate holder. Father's Name: Name of the applicant's father. Address: Full residential address including village, post office (PO), police station (PS), district (Maldah), and state (West Bengal). Gram Panchayat: The specific local governing body region (e.g., Pakuahat, Chandpur, Jagdala, etc.). Caste: Category classification (all entries are SC). SubCaste: Specific Scheduled Caste community sub-group (predominantly Rajbanshi, Namasudra, etc.). Phone: Contact mobile number of the applicant. Relation Details: Details of family lineage or older reference certificate numbers used for verification (e.g., relation type like Real Brother or Father, along with old reference certificate numbers). Action: Status indicator or verification action tag (e.g., Verify).