Separate contents of columns to its own sheet

[qaeasy]

Hello,
I am trying to to separate my contents of a column to its own sheet. Is there an easier way to do it rather than filtering by name and copy pasting to new sheet.
In the sheet attached. i want to Region Alex to have its own sheet and Region Brouge to have it own other sheet.
Currently I filter region by Alex first, copy the data and paste it to a new sheet and same for 17 other regions.

Any help would be greatly appreciated.

Thanks

[CARACALLA]

alex

A2=IF(COLUMNS(alex!$A$2:alex!A2)<=2,IFERROR(INDEX(Sheet1!A$2:A$100,AGGREGATE(15,6,ROW(Sheet1!A$2:A$100)-ROW(Sheet1!A$2)+1/(Sheet1!$A$2:$A$100="alex"),ROWS(Sheet1!$A$2:Sheet1!$A2))),""),"")

Copy across and down

brouge

A2=IF(COLUMNS(brouge!$A$2:brouge!A2)<=2,IFERROR(INDEX(Sheet1!A$2:A$100,AGGREGATE(15,6,ROW(Sheet1!A$2:A$100)-ROW(Sheet1!A$2)+1/(Sheet1!$A$2:$A$100="brouge"),ROWS(Sheet1!$A$2:Sheet1!$A2))),""),"")

Copy across and down

[wk9128]

Define a name : name

formula

worksheet name : alex
Cell A2 formula , Drag down and across

Copy Worksheet name : alex
Ranges A2:15 to worksheet name brouge