Omg that's awesome mate! that's almost exactly how I want it! is it just pulling the link from the other worksheet? "legal requirement" were I have them other links? in other words how do I finish off the rest of the reminding sections in the drop down?

and would I just copy this formula for all the other collumns I have e.g. "legal resources"

Thanks so much!