I have roughly 10,000 individual XLSX workbooks that must be consolidated into a single, clean data set. After the merge, I need every duplicate entry pinpointed strictly on the combination of Name, relative name, and age. Once the duplicates are found, I want a second sheet that groups those repeated records assembly-wise so I can immediately see which assembly codes are generating overlap. The finished deliverable should be: • assembly wise excel sheet where duplicates are marked, one voter data may be duplicated multiple times, I need in which assembly, which part number, at which serial number with which epic id data is Duplicated • A separate tab where which data is Duplicated how many times, as a consolidated report Feel free to rely on Power Query, VBA, Python pandas, or any tool you trust, so long as the end result arrives back to me in standard Excel format and can be opened without additional dependencies. Accuracy is critical; I’ll spot-check both the consolidated sheet and the duplicate report before sign-off. This work is urgently required in 3 hours tonight