I need a Python-based routine that can open batches of Excel workbooks and PDF reports, pull out both the text and numeric fields they contain, run the required data transformations, and drop everything into a single, tidy Excel file that’s ready for analysis. Here’s the flow I have in mind: • Source files: a mixed set of .xlsx and multi-page PDFs. • Extraction: every relevant text label, number, and date must be captured—no copy-paste shortcuts. • Transformation: reshape columns, standardise units and naming, and apply any other logic we agree on so the final sheet is analysis-ready. • Output: one well-structured .xlsx workbook (extra tabs are fine if it keeps things clear). • Logging: the script should create a simple log file that notes processed filenames, row counts, and any skipped records or exceptions. • Documentation: brief setup and run instructions so I can rerun the job on new files without hassle. I’m aiming for a repeatable, error-free workflow, so clear, commented code is essential. Fast turnaround and open communication matter more to me than fancy UI work; as long as the extraction and transformation are bulletproof, we’re good.