Sheila is the anglicized Irish Síle — itself from the Latin Cecilia ("blind, heavenly"). In Australia, "Sheila" is informal slang for "woman" (since 1832).
Sheila does not currently appear in the US Social Security Administration's top 1,000 girls' names, so we don't publish a US rank or birth count for it. That says nothing about the name's standing elsewhere in the world — only that it sits outside the ranked US data we rely on.
In Pythagorean numerology the letters of Sheila reduce to 9, The Giver. This is a traditional interpretive system, not a factual claim about the name.