There are actually a couple names I’ve heard in that context. “Aunt Martha” and “Aunt Gertrude” also seem to be used generically in a similar manner. One could guess that because these were common names at one time, then as they aged, large numbers of people had aunties with these names.
I’m interested to see if anyone can find a specific reference on the origin?
Meanwhile, you made me wonder about “Bob’s your uncle” (since everyone seems to have an Uncle Bob) and I tripped over this unrelated yet interesting theory as to the origin of that expression: http://www.worldwidewords.org/qa/qa-bob1.htm