Quick way to add Sheets

Where is the list of 207 schools names?

Whoa, whoa!

Why would you want to do that? Whenever you feel the need to create sheets to differentiate between things like weeks, months, departments, staff names, product, schools...etc. then you should ask yourself why and what the overall object is.

For any serious application and if you want to be able to analyse or summarise data you should always keep data in a single normalised two dimensional table of column field headers and unique row records. In your case a sheet that contains columns for

Start Date
End Date
School Reference *
Threat Reference '* values here would be 1, 1.5, 2...etc,
Baker Acted
Value/Mark or whatever goes in each current threat column
Optionally you could have a column for the threat description which would contain a formula to lookup the threat ref

I really would urge you to reconsider your layout. You are just storing up difficulties otherwise.

The * values could be Validation drop down cells from which you could pick values. The way I normally arrange these things is to have a single data entry row above the database in which the new values are entered, then a button which runs a macro that adds the new record to the database.

You'd then have the powerful Pivot Table functionality available to you as well as all the standard data functions

instead of maintain data in different different sheet. Suggest to maintain data in one sheet with (add column) school name.