Hi Paul,
Thanks for responding. I did run your code and it has shaved some time off, however still sitting at 3 minutes (ish) to run all 3 codes together. I was really hoping to have this time reduced down to less than a minute but will take onboard your advice and keep playing with it to see if I can get something to stick.