Attempting to populate data to a Master sheet from 10 other workbooks / sheets

I have been given a job I don't have a clue how to do. My eyes are now going out of focus from staring at the screen. I am attempting to populate rows of data into one Master spreadsheet from 10 other separate spreadsheets (all with a 100 rows of data). It would appear that my amateur skills are lacking and that macros and/or tricky formula is involved.

I am hoping to get the 100 plus rows of data from each individual spreadsheet and automatically populate them into chronological date order in one master spreadsheet (a bit like a data base). I feel that this is possible but I am stuck? Your input in to solving this problem would indeed be greatly appreciated.

Regards, George

OK. Thank you. I shall give it a try.