Google Script to sit over various individual google spreadsheets and sort them with totals

I am after someone that can write a google spreadsheet script that will extract from various individual google spreadsheets (that all use the same layout and are effectively copies of each other although they have different data entered into them) There are 3 sheets within the google spreadsheets one for income, one for expenses and one as a chart of accounts. I would like to be easily able to add the script to the spreadsheet that would enable further sheets to be created for the various reports I wish to run from the data contained in the first 3 sheets. The script would show up as a drop down menu being reports located near the top of the spreadsheet and have just two options "profit and loss and balance sheet summary" and "profit and loss and balance sheet - detail" . The report created on the new sheet would then have the option to print or email. Everytime the report is run it would overwrite the previous report written. Maybe I need to creat a pivot table with this script. Here is an example of a google spreadsheet I want to run the script and the pivot table??? for [login to view URL]