Hello Excel Geniuses!

I am trying to develop a macro in Excel 2003 that can extract numerical data from PDF files that I store in a common folder and that I receive daily. The PDF's are a single page and contain two tables with different tittle and different numerical data. I am hoping to be able to develop a code that will allow me to automatically extract the data by file name (generally by progressing date that will be included in the file names). I would need the first table within each pdf to self organize data horizontally across 12 cells on one worksheet, and would require the second table within each pdf to self organize horizontally across 10 cells on a separate worksheet within the same workbook. I have been trying for hours to find a code similar to this that I could edit to get the desired result, but have been unable to do so. I have made one that can extract data from a single file, but it extracts both text and numbers and does not organize itself at all, and I manually have to go into the macro to change the file I want to extract data from. As I am sure this code is very hard, this is a last ditch effort, and I am just hoping there is an excel whiz out there who can help me!

I appreciate any input anyone would have to offer; thanks for your time.