I’ve found a work around. By changing the worksheet names in the secondary sheet it allows me to use the worksheet reference number rather than the name. I’m not sure why this works but it does. Thanks for your help.