Dramatic X-ray variability in AGNs: New insights into black hole fueling