Cholesterol is a vital lipid molecule for mammalian cells, regulating fluidity of biological membranes, and serving as an essential constituent of lipid rafts. Mammalian cells acquire cholesterol from extracellular lipoproteins and from de novo synthesis. Cholesterol biosynthesis generates various precursor sterols. Cholesterol undergoes metabolic conversion into oxygenated sterols (oxysterols), bile acids, and steroid hormones. Cholesterol intermediates and metabolites have diverse and important cellular functions. A network of molecular machineries including transcription factors, protein modifiers, sterol transporters/carriers, and sterol sensors regulate sterol homeostasis in mammalian cells and tissues. Dysfunction in metabolism and transport of cholesterol, sterol intermediates, and oxysterols occurs in various pathophysiological settings such as atherosclerosis, cancers, and neurodegenerative diseases. Here we review the cholesterol, intermediate sterol, and oxysterol regulatory mechanisms and intracellular transport machineries, and discuss the roles of sterols and sterol metabolism in human diseases.