Please can someone urgent help me with VBA code to sort and copy data from one sheet to another? I have a "Master" sheet and need to sort and copy it into another 16 sheets. The 16 sheets data is sorted and copied from the Colum "Division" (B) and "Region" (A). Attached is a sample with all data already copied into the correct sheets? For example: The Master sheet is sorted by Colum B (Division) and then only the sorted data "KKS" in Colum B is copied to the KKS sheet. The KKS sheet is then sorted by Colum A (Region) and then copied to 5 different sheets (Regions) for example all KKS GNT, KSS FS, KSS KZN etc. to each own sheet (Region). This is for the first 6 sheets. Sheet 7 takes all the sorted data in the Master sheet Colum B (Division) for ESS and the copied to the ESS sheet. The rest of the sheets work the same way as sheet 1 -7.