Need vba code to pull data across sheet depends upon command button click

Hi experts

I have set of data in two sheet, i want copy data from 2 sheet , paste into corresponding value sheet name, through multiple command buttons


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

Yes even i think its really complicated to view report if too many buttons here and there i want make simple only all report East and south data from both sheet

can u do once click all report button onlly east and south data fill range?

please find attachment

Hi sir it works perfectly, i try same code for my sake it show error i try to implant code for state column c:c but i getting error can u help to learn where did i made mistake?

Thanks Master my dream come true!! solved