Copy grouped excel details to another tabs

I have an Excel file with lot of data to be grouped and i want all those grouped data to be copied to another worksheet with alphabetical order. That means, the first group data to be copied to the first tab of the excel and the next tab to be copied on the second tab and so on. Are we able to make a macro to do the same?