Case in point: if my house appreciates on the market by $100K, I am $100K "richer"; this by itself doesn't increase the circulating money. But if I'm able to borrow $100K by mortgaging the increased value of my house, now I have $100K more to spend. The lender has $100K less in their bank account, but they now have a mortgage-backed security which is worth $100K and that, if there is a liquid market for such securities, can be almost as good as actual dollars for trading. The circulating money has increased.
It gets even worse. If the lender and/or the borrower use even just a part of those $100K to speculate in the housing market, the bubble will accelerate... until, at some point, enough people actually want to use their new riches to buy products that aren't part of the asset bubble, and producers of those products don't accept those inflated securities as payment. Then, the bubble bursts.
And, by the way, this whole mechanism has nothing to do with bad central banks or fiat money. It's perfectly consistent with a perfect free market AFAIK, and the only (not easy at all) way to prevent it is regulation.
On some level it's all as simple as we intuitively think it is. I think the difficulty is coming to the realization that it's turtles all the way down--there's no magical, true price where book-value perfectly reflects all "real" assets. This dynamic complexity is most apparent when you dig into currency exchange rates, where you very often get very counter-intuitive results when you [literally and figuratively] follow the money. I'm by no means an expert, either in finance, accounting, or math. But I did study international economics in undergraduate, which has helped me to internalize the notion that there's no "true" price to anything except for what others are willing to exchange at any one moment, given all their imperfect information and incentives. And in graduate school I took an economics course with a professor who wrote one of the first studies (commissioned by Toyota) that empirically showed how exchange rates fluctuated in response to current account surpluses and deficits, in turn effecting demand & supply--a phenomenon everybody now takes for granted but which was not widely appreciated at the time even though it's obvious in retrospect. He really only mentioned it in passing one day, but the concept really stuck in my head and has helped me to conceptualize (albeit very imperfectly and at a high level) that valuation is an ongoing process; quantifying it at a fixed point in time is less meaningful than we intuitively believe.
But don't take my word for any of this. One of the most enlightening books I've ever read is "Lords of Finance: The Bankers Who Broke the World", which won the 2010 Pulitzer Prize. I read it in 2010, shortly before I read The Big Short, because of the accolades and because I wanted some context to the economic crisis. It's partly a scholarly work which makes it little dry, but its still very accessible. Basically, everything I said above about the role of the gold standard in the interwar period (WWI to WWII) comes directly from that book. Reading the Big Short explains how the mortgage-backed securities market works. It helps to have some grounding in economics to really maximize your dividends from reading those books.