Submillimetre Studies of Prestellar and Starless Cores in the Ophiuchus, Taurus and Cepheus Molecular Clouds