Dance Card Matrix Maker

I need an excel spreadsheet that can make dance cards automatically The input will be First Name, Last Name, Age, Sex, I need the spreadsheet to generate dance partners based on this criteria. User must enter number of dances to generate. Factors to consider: Males dance with females and females dance with males. Age matching should utilize a bottom up methodology. Youngest male dances with the youngest of the females on up. The importance here is that especially for kids, girls do not care to dance with boys younger then them. This may not be possible depending on the entries but in the formula should take this into consideration keeping the age gap between male and female that the male is equal to or older whenever possible. Favoritism should be given to a +1 year or equal age whenever possible for male to female. All the time whichever parameter or combination of parameters is turned on, these are not determinates to exclude a dancer. Things to consider. If uneven number of participants exist the grouping with the fewer number should have full dance cards, i.e. 45 males and 30 females would mean that all females would have full dance cards while males would have partials by default. However if an over all option to "create ideal pairings" could be incorporated, this would allow for pairings to be completed only for those that matched the selected criteria and were within parameters. Finally, a worksheet should be generated with the Male Matrix one for the female Matrix.