I've sorted it
There was a file called .nomedia in my videos folder within the SD card..
Which I deleted and then did clear data for movie/album/ media storage apps
Then did a reboot then went into storage in settings and clicked on photos/ videos
and all videos etc. appear now from SD card in all Sony apps.
Hopefully it may help someone in the future.