Does this whooping whistling cheering noise have a name?

Solution 1:

Some sources refer to this noise as the “disco call.” For example, it appears in the index of Turn the Beat Around: The Secret History of Disco as “‘Whoop! Whoop!’ (disco call),” and the Beastie Boys refer to it in their song “Shake Your Rump”:

Oowah, oowah is the disco call

It looks like the the sound may have originally been referred to as a disco call, then later as the disco call, perhaps because it's the best-known example.

Solution 2:

I believe that since you seem to be talking about a very specific sound people have been making only in the past few decades, an onomatopoeia might suit your needs better. I think a simple "whooOop - whooOOP" would probably work in context.