Winomkar Excel Data Automation

I need an automated workflow that pulls mixed text-and-number records from our Winomkar Excel workbooks, processes them, and returns clean, ready-to-use sheets without any manual touch-ups. The script (whether built in Python, VBA, Power Query, or another reliable tool you prefer) must open the source files, carry out the required data operations, and then save or export refreshed results in the same folder structure.

Please make sure the automation:

• Sorts rows according to the parameters I can define at run time
• Filters data on multiple columns with dynamic criteria
• Performs built-in or custom calculations as specified in a config section
• Copies results to designated summary sheets
• Validates every entry against simple rules I will provide (e.g., mandatory fields, data type checks)
• Generates a concise report summarising any errors or outliers it found

A clear, well-commented codebase, brief setup instructions, and one example run on my sample files will be considered acceptance criteria.