Obviously this cannot be true. "The economy" isn't some magical object somewhere, but the emergent behavior from all our needs, desires and faults. If something is truly not wanted by anyone, nobody will pay for the work to get done. That's the magic of the invisible hand of capitalism. Doing stuff that truly nobody wants and getting paid for it is usually more of a feature of socialism and bureaucracies.
There are cases where individual motive leads to macro behavior that's not desirable by any individual, those are the cases where we need to tax negative externalities or regulate, depending on the problem. These issues usually don't emerge though because nobody wants something but because too many wanting a thing creates side effects that nobody likes. The book Micromotived and Macro behavior by Thomas Schelling covers that nicely.