PDF Data Extraction Automation to Excel

I'm seeking an expert to automate the process of extracting both text data and tabular data from a variety of PDF files into separate sheets in Excel corresponding to each PDF. The PDFs are inconsistent in their structure and layout, which adds a layer of complexity to the task.

Key Requirements:
- Can use excel, Adobe, Python

Please provide examples of previous similar projects you have successfully completed.