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.

Main sheet				Sheet name
Sheet1	Option	Strike	Expiry		ABC
Abc	P	11600	27-Jun-19		Column A	Column B	Column C]
Xyx	c	11500	27-Jun-19		P	11200	27-Jun-19
PQR	c	11400	27-Jun-19		P	11200	#####
					P
					P
					c	11200	27-Jun-19
					C
					C
					C
					S
					S

<colgroup><col span="8"></colgroup><tbody>
</tbody>