Extract Information from PDF file transfer to Excel

In a folder, I have several PDF files. And I would like to extract some information and I want that information to be transfer to an excel spradsheet. Attached are sample files of the PDF file with information and the output file I need in Excel. 1. The information will be extracted ONLY from the files that end in .smry 2. The information I need to be extracted and display in a spreadsheet is the following: a) The filename without the .smry that column will be "Batch Smry" b) The RUN number, that column will be "Run No." c) The SKU, that column will be "SKU" d) The Description, that column will be "Description" e) The Quantity, that column will be "Quantity" 3. I also need a summary of the Quantities. See excel file attached for details. I do not know how is the best way to accomplish in terms of language or how to do it. You tell me. I run Vista, have office 2007. Thanks!