I hope someone can help.
We currently have jobs completed on a spreadsheet, it essentially have simple information such as name, address, number, description, etc. Once the form is completed, it is all saved within a folder. These files are are saved under the format Name and Date, ie JoeBloggs29102015.xlsx
Is there a way, I can have a master spreadsheet which will automatically scan the folder and list the information in those individual spreadsheets and place it into the master spreadsheet?
I've provided some sample data to show what I mean.