Hello from Steved

I have sheet1 labeled Data, Where the below is stored

I've Labeled 8 Sheets as an example 1-City, 2-Roskill
and so on. Question in vba please could somebody please
write me a code that would copy from the Data Sheet to
the 8 individual labeled sheets. Thankyou.

Depot,Name Operator,Count Annuls,Annul Value Total, Period
1-City 10925 27 29.60 200511
1-City 10943 27 54.90 200511
6-Orewa 60124 28 67.44 200511
6-Orewa 60123 17 42.10 200511
8-Panmure 10903 27 54.04 200511
8-Panmure 10915 27 45.80 200511
3-Papakura 86076 48 122.70 200511
3-Papakura 86030 30 69.54 200511
2-Roskill 20824 42 35.38 200511
2-Roskill 20751 36 83.30 200511
5-Shore 50636 40 82.60 200511
5-Shore 50600 34 104.80 200511
7-Swanson 70468 40 59.94 200511
7-Swanson 70478 39 109.50 200511
4-Wiri 40677 35 64.40 200511
4-Wiri 40662 28 58.00 200511