The Webelos Super Achiever award is for Webelos who earn all 20 Webelos activity badges. This is a council specific award, not a national award. So while many councils offer this award, some do not. You will need to check with your local council.
With my Webelos den, I know most of the Scouts will not get this award. But for the Scouts who are really into earning stuff, this makes a nice goal. With my previous den, I had a couple who completed their last activity badge during their last month as Webelos. The thought of earning this badge gave them the little incentive they needed to push themselves.
There is no long list of requirements for this one. In our council (GSLAC), the Webelos just need to earn all of the activity badges. Other councils might add an additional requirement or two.