need a solution for following scenario

[peee2]

I want to paste option strike and expiry columns data in respective sheets name mentioned on the left.
This is how the respective sheets looks like.
In sheet ABC So rather than adding data in different row the macro should first look if there is blank in Column B. If there is then paste data there and if there isnt then paste data in next possible row.
Its a mammoth task for me.
Please help.
[TABLE="width: 512"]
<colgroup><col span="8"></colgroup><tbody>[TR]
[TD="colspan: 2"]Main sheet[/TD]
[TD]

[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Sheet name[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sheet1[/TD]
[TD]Option [/TD]
[TD]Strike[/TD]
[TD]Expiry[/TD]
[TD][/TD]
[TD]ABC[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Abc[/TD]
[TD]P[/TD]
[TD="align: right"]11600[/TD]
[TD="align: right"]27-Jun-19[/TD]
[TD][/TD]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C][/TD]
[/TR]
[TR]
[TD]Xyx[/TD]
[TD]c[/TD]
[TD="align: right"]11500[/TD]
[TD="align: right"]27-Jun-19[/TD]
[TD][/TD]
[TD]P[/TD]
[TD="align: right"]11200[/TD]
[TD="align: right"]27-Jun-19[/TD]
[/TR]
[TR]
[TD]PQR[/TD]
[TD]c[/TD]
[TD="align: right"]11400[/TD]
[TD="align: right"]27-Jun-19[/TD]
[TD][/TD]
[TD]P[/TD]
[TD="align: right"]11200[/TD]
[TD="align: center"]#####[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]c[/TD]
[TD="align: right"]11200[/TD]
[TD="align: right"]27-Jun-19[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]S[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]S[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]