Summarizing Spreadsheet

Hi, I have a large number of a standardized excel spreadsheets in a single folder that I need to make a summary document of. The standardized spreadsheets contain multiple tabs and I only need to record values where data has been entered in a particular worksheet. I need someone to design a spreadsheet for me that will do the following 1) Create and save a summary workbook in a named directory 2) Record the value of a particular set of values in each worksheet in each workbook where the entry is not empty. For all files stored in a named folder 3) Display the information in a neat and user friendly way 4) Should be able to update the summary workbook with new files that have been added to the directory I will supply the standard spreadsheet to be summarized to the selected bidder. Kind Regards, Fergal