A total of eight Met Office yellow weather warnings for wind and rain will be issued between Friday and Sunday