In a small saucepan, bring water and sugar to a boil over medium-high heat, stirring occasionally, until sugar dissolves. Let cool completely.

In a pitcher, combine sugar mixture, rosé, sherry, peaches, plums, and cherries. Cover and refrigerate until chilled. Add club soda just before serving.