How to write a macros to compare to columns & match amounts, but this is a bit more tricky

Ok guys so i pull in a report. On the left side its the rebates that AP have applied. On the right side its what AR applied.

Column D is totaled and its sum should match to the sum of column S. If they don't something is off and i have to manually search which amounts are off.

So in sheet 2 i paste Column D for AP side rebates into column A.

Column C and so on, is column S, T, Z and AF.

Columns T Z and AF are basically totaled together to get what you get in the S column. So the way i manually do this in sheet 2 is if Column C does have a combination of totals, i delete whats in column C, and Put whats in columns D, E and F, into rows in Column C. Example


Column C D E F
18,869.23 909.23 803.00 17157.00

turns into:

C
909.23
803.00
17157.00

So this pushes the numbers beneath it down accordingly. If column C & D are equal i just delete whats in the D cells. All this is seen in sheet 3. Then in sheet 4, i sort them my least to greatest and find whats not adding up.

Is there a way to write a macros to do this for me?