Live PDF to Excel Extractor

I have a designated Windows folder that keeps filling up with new PDF reports. Every table or other structured block of data inside those PDFs must land in an Excel workbook automatically, without me pressing a button.

Here is the core workflow I need built:

• The moment a PDF is dropped into (or removed from) the monitored folder, the solution scans it, pulls every table or structured dataset, and appends the results to an ever-growing database area in Excel. No data should be overwritten.

• Each row (or logical record) must include the source-file name and timestamp so I can trace anything back to its original PDF.

• The Excel layout itself—columns, headers, any calculated fields, summaries, or pivot tables—will be finalised together once the extraction logic is proven.

• The solution has to run quietly in the background. A macro-enabled workbook, a small Python script called from Power Query, or another lightweight approach is fine—as long as the update feels instantaneous and the workbook stays open-friendly for everyday users.

Acceptance check: drop a fresh PDF with tables into the folder and watch Excel add the new rows within seconds, without affecting existing data.

Let’s get this set up so the workbook becomes my live dashboard, not yet another manual task.