Macro Code to Dynamically paste range in a new sheet

[Sylvine]

I need help with a macro formula that can paste the different coloured ranges as shown in different sheets by utilizing Order Id and status and looping to next id after pasting first. for example the range highlighted in green would be pasted in one sheet, blue one in another and red one in another sheet

 

[ExcelToDAX]

What would be the Sheet Names? Based on what you've said so far, it would have 3 tabs called Green, Blue, and Red. Are you manually coloring these cells and then wanting to run a macro to put into the other tabs? Or is it more specific of the Order ID (i.e. Iphone, Jacket, Accessories).

 

[Sylvine]

What would be the Sheet Names? Based on what you've said so far, it would have 3 tabs called Green, Blue, and Red. Are you manually coloring these cells and then wanting to run a macro to put into the other tabs? Or is it more specific of the Order ID (i.e. Iphone, Jacket, Accessories).

the sheet name should be extracted from order ID. For example: Considering table to be present in sheet1, sheet2 should be named as Iphone and first three rows should be pasted. The colours are only for separating ranges.