I’m not sure if this answering attempt is correct in the light of Mithoron’s and ron’s comments on your question, but this is the way I learnt it, so if this is wrong I will at least learn something, too.
We all know what s-, p- and d-orbitals look like, but what is the significance, and why do these orbitals preferentially form $\sigma$, $\pi$ and $\delta$ bonds, respectively?
Mathematically spoken, orbitals are functions of the hydrogen atom that solve the Schrödinger equation. The model in question is a non-rigid rotor,* i.e. the rotor’s axis is not fixed in any spatial direction (the electron can rotate freely around the nucleus). For solving this equation, it is helpful to use polar coordinates $(r, \varphi, \theta)$, mainly because the solution can be split into a radial factor (dependent only on $r$) and angular factors (dependent on $\varphi$ and $\theta$).
$$\Psi (r, \varphi, \theta) = R(r) \cdot Y(\varphi, \theta)$$
$R(r)$ can be thought of giving an orbital its extension into space while $Y(\varphi, \theta)$ gives it its shape. Both functions depend heavily on quantum numbers: $R(r)$ does so for $n$ and $l$ while $Y(\varphi, \theta)$ depends on $l$ and $m_l$. For the simplest case ($l = 0; m_l = 0$, s-orbital), $Y (\varphi, \theta)$ degenerates to a simple constant, meaning that the orbital will have a totally symmetrical spherical shape. $l = 1$, (the p-orbital) while loosing spherical symmetry, still keeps total symmetry with respect to one axis, i.e. every slice you take through that orbital perpendicular to the axis of symmetry will be a circle. Higher quantum numbers lose more symmetry but it’s not always as easily visualised, so I’ll stick with these.
But you were talking about bonds, where do they come into play? Well, bonds also have a symmetry, but they also have an axis instead of a nucleus, so their symmetry will be reduced per se. The simplest symmetry along a bond axis is total rotational symmetry around the bonds axis. I hope you see the similarity between the s-orbital (total symmetry around a central point) and a $\sigma$ bond (total symmetry around the bond’s central axis). Similarly, a $\pi$ bond will always have one degree of symmetry less, which turns out to mean ‘having a plane of symmetry that includes the bond axis’. And a $\delta$ bond will have two planes of symmetry — yet another degree of symmetry less.
According to this definition, an orbital that can take part in a $\sigma$ bond needs to have full rotational symmetry along the bond’s axis. That means, that there is only one, at most two orbitals that fulfil the criterion (but if there are two, one is going to be an unmodified s-orbital and likely not take part in bonding at all). Therefore, only one $\sigma$ bond would be possible between two atoms.
Writing this up, I remembered the ‘banana bonds’ that were introduced to us to explain the extremely small ($60°$) bond angles in $\ce{P4}$. I would need to go back, recheck and rethink what I would think of those and if I would treat them as exceptions of this ‘rule’ or simply as special cases that need additional information to be discussed. They certainly deserve consideration, as they are, de facto $\sigma$ bonds from the way they look, even though they do bend.
An interesting comment was left on the question pointing to sextuple bonds. I didn’t know bonds of that order existed; my knowledge was stuck at 4. For a quadruple bond, possible between certain transition metals such as in $\ce{[Re2Cl8]^2-}$, four of the five d-orbitals form a bond to the other metal; one being $\sigma$, two being $\pi$ and a fourth one of $\delta$ type (to planes of symmetry). Extending that to a quintuple bond by adding a second $\delta$ layer with the last remaining pair of d-orbitals isn’t hard.
The sextuple bond – eg $\ce{Mo2}$ — derives from an additional $\sigma$ bond between the s-orbitals of the higher shell. You thereby solve a problem you would otherwise have: The $4\mathrm{d}_{z^2}$ orbital can take part in $\sigma$ bonding along the $z$-axis; and the higher $5\mathrm{s}$ orbital is more diffuse, extends further into space and therefore is still able to form a contact to the neighbouring atom’s counterpart. Because it is more or less a sphere, it can only form $\sigma$ bonds.
* I don’t think this is the model’s correct name. In my German quantum chemistry class, the rigid rotor was a raumstarrer Rotator and thus the model here was a raumfreier Rotator. Somebody who might know the proper name please comment (or edit).