Rolling Stones - Ruby Tuesday, Angie
Beatles - Dear Prudence, Juila, Michelle
Who - Pictures of Lily
Velvet Underground - Sweet Jane
Ramones - Sheena is a Punk Rocker
Beach Boys - Help Me, Rhonda
CCR - Suzie Q
Kinks - Lola (sort of)
Nirvana - Polly
Flaming Lips - Yoshimi Battles the Pink Robots Pt. 1
I have a theory that artists intentionally write songs named after women or types of women (the classic example here is Van Morrison's "Brown Eyed Girl") so that they can sleep with groupies who resemble them in name or appearance while on tour.