Moving information into a new spreadsheet format

The school district has requested out studen ID information in a spreadsheet format that is different from how we currently list the information.

Currently the spreadsheet is broken out by school tabs (see attached screenshot of current). The new format is just one long list by student ID (see attached new format). We work with about 65 schools and have already moved about half to the new listed format. So, we have a working template, it is a lot of copying and pasting and checking to ensure that all information has been translated to the new format correctly.

The spreadsheets are in google sheets, so much have access and experience with google sheets.

Once we agree on terms and start the project we are looking to have the work completed within 5 business days.