Naturally, haloacid dehalogenase superfamily phosphatases have been evolved with broad substrate promiscuity; however, strong specificity to a particular substrate is required for developing thermodynamically driven routes for manufacturing sugars. How to alter the intrinsic substrate promiscuity of phosphatases and fit the "one enzyme-one substrate" model remains a challenge. Herein, we report the structure-guided engineering of a phosphatase, and successfully provide variants with tailor-made preference for three widespread phosphorylated sugars, namely, glucose 6-phosphate, fructose 6-phosphate, and mannose 6-phosphate, while simultaneously enhancement in catalytic efficiency. A 12000-fold switch from unfavorite substrate to dedicated one is generated. Molecular dynamics simulations reveal the origin of improved activity and substrate specificity. Furthermore, we develop four coordinated multienzyme systems and accomplish the conversion of inexpensive sucrose and starch to fructose and mannose in excellent yield of 94-96%. This innovative sugar-biosynthesis strategy overcomes the reaction equilibrium of isomerization and provides the promise of high-yield manufacturing of other monosaccharides and polyols.