A future for Leeming?
Sorry, slightly off thread.
Surely it's blindingly obvious. 10 miles up the road from Leeming is the biggest Army Garrison in Europe.
The Army uses a lot of the talents and services of the SH Force.
The SH Force have to trog all the way up north to provide those talents and services.
Move the SH Fleet to Leeming and keep RAF Yorkshire in existence.