Sheffield, Northallerton, Leeds, Bradford, York and Doncaster have yellow warning in place from the Met Office