transformation of data?

Hi

Here is a revised version that copies data as well.

However you will note that there are some gaps in the data, as far as I can tell it is where columns have been transposed in some of the sheets, i.e. teacher a to b and vice versa, I think it should be okay if this is corrected.

If I get a chance later I will try and explain a bit more.

Regards

Jeff