PDF Documents into one excel spreadsheet

[AHUS]

Realised everyone on here has some pretty creative ideas so thought it would be worth posting a current problem I have.

I generate PDF reports which have information under different headings.

I'm looking to create an excel spreadsheet which:

1) Tracks these reports and (potentially) fills out summaries into columns
2) Provides a link or the pdf itself to click onto and read the full report

I am currently thinking to manually enter the information into columns about the summary, and then attach the pdf itself on the same row to find out more information.

Is there a more efficient way to do this? i.e. drag and drop the pdf into the spreadsheet and the respective row fills out the summary columns itself

Thanks!!

[ben_hensel]

Pulling information out of PDFs is pretty dang hard.

If you're generating them from somewhere, and you have control over that, I'd recommend that you step back to there and have that report-generating-application output a second file that is more friendly to being processed by another program -- like another excel sheet, say.