Upload an example of exactly what it's supposed to look like after the macro has run. As you have it now every cell will be Value 1, Value 2, Value 3 + the source cell colour etc etc. The macro can copy whatever is in the cell on the source sheets including the colours to the Total sheet, the problem comes with the sorting, especially if you have a mixture of text & numeric.