Copy all rows when criteria in Row is met

[GedSalter]

I have a chart In Column AZ there are a range of texts ("Sort 1", "Sort 2", "Sort 3") These range can go up to about Sort 40. There can be as little as 1 row in each Sort and as much as 60 rows. I wish to copy all rows in a the range (BA:BD) into another worksheet ie worksheet ("Sort 1") Range (A2)when the Text in Colomn AZ states Sort 1. All worksheets already created.


Is it better to do Via VBA or using an Array? I am not sure how to do either way to be honest. Any help will be appreciated.


regards

Ged