MS Excel VBA Application template

We need a MS Excel VBA application that consolidates 3 excel files into one single file. General MS Excel 2010 Sheet 1 will contain a input field for data location. Fields to hold the identified import files A load file button to activate the import A file mask section where the user can define a mask that allows the identification of the import files A section where unrecognized files shall be listed. The application shall serve as a base structure and template for further development. Detail import functionalities will be done by us. A sample master file and sample input files as well will be provided by us. Steps file selection 1 Select the directory where the Excel files to import data from are located by pressing buton brows 2 If 'load files' is pressed 3 Check for each file whether it matches one of the file mask. 4 If a file matches add it to the corresponding input fiels (File A, B, C or D) 5 Files that doesn't match to any of the defined masks shall be listed below 'Unrecognized files'. Error situations No excel file found in submited directory File for one or more file type is missing … .. . Steps Data Import 1 Select source data 2 check if destination contains already the source data 3 If not append data to destination. 4 Update calculated column Error situations Source column not found Destination column not found … .. . File Mask File masks is used to setup the expected field content for a specific file by defining 5-6 Fields at a known position. This is to be set by the user!