I don't usually talk anatomy because, as interesting as it might be, as a model for movement it can become thoroughly misleading.
But If you want to understand why you might be 'stiff' or have tight hamstrings/hips/shoulders/back, here's an anatomy lesson for you that makes sense of it all as well as what you actually need to do to change things (and its nothing to do with manipulating connective tissue)