Dear All

I have the following data:

Sheet1
Columns: A=STATUS, C=GROUP, D=FIRST NAME, E=LAST NAME
STATUS=1,2,3 the rest are text and several people can belong to the same GROUP

I would like the following automation:

On Sheet2, Sheet3, Sheet4, I would like column A to autorefresh with unique
values for GROUP&1 sorted by 1st-STATUS and 2nd-LAST NAME

Thank you