Excel Macro Move Splited Data to Assigned Workbook Sheet's

I have Master Workbook & 4 Working File In Path. I want move data as per unique column values in Column B:B, & Get split to targeted folder & Sheet By Comparing Data Name & WB Name.

In the master Sheet I have Unique values of B:B column & get split data as EAST,WEST,NORTH,SOUTH TO TARGETED FILE WHERE STORED IN TARGETED FOLDER

For
4 Workbook Saved in path(D:\Documents and Settings\Administrator\My Documents\Downloads)

E.g East Data's move to East Workbook Master Sheet. Next Time Add to last row of data in sheet.
NOrth Data's Move to North Workbook Master Sheet. Next Time Add to last row of data in sheet.
South Data's Move to South workbook Master Sheet. Next Time Add to last row of data in sheet.
West data's Move to West Workbook Master sheet. Next Time Add to last row of data in sheet.

Please Find the attachements

Regards