Arranging a worksheet in a specific way by Macro

I have a sheet containing daily reports showing the compositions of samples taken from 6 different equipments. These daily reports are placed under each other in one workbook as shown in the attached...