Python developer needed

I have a folder with roughly 2,000 PDF invoices that all share the same layout. From each invoice I need five key details— I’ll share the exact fields in chat. Your task is to write a Python script that scans every PDF, captures those values, and exports them to an Excel workbook where each invoice is represented in multiple rows (one row per captured value, following the order I supply).

The script should:
• work on Windows with a simple command line call,
• rely only on widely-used, open-source libraries (pdfminer.six, PyPDF2, camelot, pandas or similar),
• handle the entire batch in one run and skip any file it can’t read while logging the error,
• produce a clean .xlsx ready for review—no manual copy-pasting.

I’ll validate the job by comparing a random sample of invoices against the spreadsheet, so accuracy is critical. Once the results line up and the code is commented well enough for me to tweak field positions later, the project is complete.