Hi,
What I understood from the details is, there is information in SBAC Math and ELA sheet for students of all the grades (6,7 and 8) in 24 columns.
This information should be made available in the other three sheets for the respective rows.
If yes, this can be done using complex VLOOKUP function and I can easily do this.
I have got over 12 years of experience in advanced excel including lookups, sorting, filtering, pivot, graphs etc. working with one of the TOP5 consulting companies worldwide.
Please allow me a chance to work for you in this requirement. I assure for best quality in least time with lowest price.
Thanks.
Regards,
Keshav