Script to Organize Data

I need a script (in any language) to organize data from different files into one giant file. I have tables in xls and pdf files. I am not sure about the feasibility of extracting data from pdfs using a script. If this cannot be automated, then I will pay for the manual input by the provider. The detailed instructions and the data set are listed below as attachments. Please check them before bidding.