What is the origin of the idiom "like herding cats" and when to use it?

The idiom "like herding cats" is used to describe a situation that is extremely difficult, chaotic, or challenging to control or manage. It originated from the notion that herding cats is an impossible task due to their independent nature and resistance to being directed or corralled.