Help in compiling a mastersheet from various sheets

Hi, I seek your help in assisting me in creating a VBA code to automatically compile a Master sheet as per attached example. I have an excel workbook with various sheets- one for each student which is populated with data daily. I require a macro to collect data from each sheet in order to compile a mastersheet, as per attached example. Please let me know should you require further explanation. The attached is only a simple example. In reality I have hundreds of rows and columns which keep changing - ie rows and columns change. Many thanks in advance for your help, as I feel lost!

hi, Excelcreep, please check attachment, run code "test".
.

Cool! Many thanks Watersev - you saved me sooo much wrk!

if you are satsified with the offered solution, please mark the thread as solved (see Forum Rules for details)