copy rows to another sheet after merging using specific creteria

[saurabh2k26]

I have to read column 2 of each row and do following operations:
if value=step1, then copy whole row to new tab and read value of column 2 of next row. if value is step2, then append column 3 of row 1 with value of column 3 of row 2. Continue doing till column 2 contains step3,4,5 etc.Maximum steps can be till step 10.
if column 2 is again step1, repeat the whole process again.
if column 2 have a blank value or other value then stepX, then simply copy to other tab.

Please find sheet attached. Tab 1 contains input file and tab 2 is expected output.

[saurabh2k26]

Thanks in advance for the great help