The exhibition sheds new light on lesser-known, often ephemeral, works by women