A Submillimetre Study Of Nearby Star Formation Using Molecular Line Data