macro to move data from one cell to the adjacent,then to the third , then to the fourth

From your post #14:

but it may be noted that the comparison the code makes is erraneous.
there will be no comparison on day1 sheet.
on day2 sheet the comparison can only be done between E and D. see the column heading .there is data only on these two columns at present (after we run the code data from C move to D. then only the comparison should work.)

It seems pretty clear!