Archive Macro - Student Data

Hi folks,

I have a little problem writing a Macro to archive student data. PSA sheet.
I have a sheet for each student, with their associated grade, timings and number of attempts relating to different tests they do in class.

I would like to extract all student information and update the archive tab after running the macro to save me copying and pasting 30 students' data. (At the moment I have 3 students in the example).

Please note that the number of lessons will change depending on class, so the macro needs to run for each students' sheet from row 5 down until the first blank row.

I appreciate your help on this.

In a "very complicated way" ... ... very simple macro, with one modification in cell 'W1' after archiving students sheets, for testing.
Entry "Yes", to protect against re-archiving the same data.
If not needed then comment this line to prevent archiving blocking.

Please Login or Register  to view this content.

Macro:

Please Login or Register  to view this content.

Wonderful! Thank you so much for your help.