Hi Thanks for this, it does the job, however on clicking some of the hyperlinks for the worksheets (created by this macro) gives an error - "reference not valid"

Any suggestions?