sequence numbering

Hello forum guys.
I am stuck up at one place regarding sequence numbering. I have attached a sheet for making it more clear.
The required output is shown in sheet2 , but it is actually required in the same sheet named Main when you run the code.
Wanted just an option . In case if the code is run and the output is required in the sheet name Option and not Main.

Thanks and have a nice day.

jparmar