Sparkling wine in theory can have any grapes added to it, but each region tends to favour some of its own.
Champagne uses pinot noir, pinot Meunier, and chardonnay. England’s rise to fame in part mirrors the adoption of those grapes there as well. Champagne and England are both regions.
Cava is dominated by three main grapes: macabeo, xarel-lo, and parallada. Of which, the first two make excellent dry whites too. Cava is the name for Spanish sparkling wine but can only be produced in the Catalonia region.
Prosecco is the name of the grape (to add extra confusion to the naming). Prosecco can be made in Conegliano, and Valdobbiadene. It occasionally has other grapes included but less frequently than elsewhere.
Sekt is the German name for sparkling wine. Sekt can be produced all over Germany and Austria, and can use a variety of grapes including the traditional Champagne trio, and German stalwart riesling. My primer
on Sekt is a great starting point to learn more.