Need vba code to catch data from 2 worksheet into two range once click command button|VBA & Macros|Excel Forum|My Online Training Hub

Hi experts

I need your kind code for my small office work, i have set of data which is consistent same kind of data in 2 sheet, i want copy data from 2 sheet paste into different sheets depends upon Sheet Name {East,West,North,South,....} 

Like copy from sheet rawdata1 and sheet rawdata2 paste into different sheet depends upon name in sheet cell range have command button

for e.g

Condition 1 : Rawsheet1 Column B have data south and Rawsheet2 Column B have data south, from both sheet all data south copy to south sheet, 1st range(A30:G30) 2ND RANGE(I30:O30)

Condition 2 : In sheet south In column C have states data when i click state wise command button corresponded states data will be in both range

please find the attachment