data mining

We place orders on line for contact lenses. The vendor sends us confirmation as a PDF that contains much of the relevant information. We would like to create a module that can recognize the PDF, harvest data from it, and transpose that data into a Word or Excel document. The new Word (or Excel?) document would now contain the demographic data (patient's name, address, etc) and the specific contact lenses that we ordered. We would then like to be able to have the program "price" the order for the consumer with prices that are preloaded into a database that contains the price for each category of contact lens. We can, of course, update this price list at any time. Additional fields that can be entered by the operator would include shipping charge, a note, and whether the name address that are data-mined from the original form are also the billing address or if a different billing name and address need to be entered. More data that will be helpful would be credit card information (with the ability to obscure all but the last four digits on the customer receipt). * * * * I would also like to be able to use this final form to create a paper (or PDF) receipt that we send to the consumer, as well as an email that contains all of the same data as the paper receipt