Thanks for your reply and apologies for the delay in presenting more info.

As it happens I have corrected the problem. It was my error as not all data was linked to the main input sheet. That is now corrected and all seems to be as it should be.

Thanks again for your input.