Hi all, I have 4 Sheets in workbook

Sheet 1 Name: Main Data
Sheet 2 Name: 1XX
Sheet 3 Name: 2XX
Sheet 4 Name: 3XX

In Sheet("Main Data") I have data like (see below)

A B C D------col
Non 1XX 123 Bud
Non 1XX 123 Bud
Non 2XX 123 Bud
Non 2XX 123 Bud
Non 2XX 123 Bud
Non 3XX 123 Bud
Non 3XX 123 Bud
Non 3XX 123 Bud

I want macro which should check column B cells value of Sheet("Main
Data") and if that value match with any Name of Sheet in the workbook
then macro should copy that value cell row from Range(A:D) and paste
it to in range(A2) of matching name Sheet and like this next cell and
next sheet. For example according to above data in Sheet("Main Data")
macro should check column B cells value and in first two cells value
is 1XX and there is Sheet which name is also 1XX so macro should copy
these two cells rows from Range(A:D) in that Sheet in Range(A2) and it
should continue untill there is no value in column B cells. I hope I
was able to explain my question. Please can any friend can help