Hi everyone,



how can I copy the source data going to (destination) sheet:
> that is formulated sheet; and
> needs to be sorted (alphabetical order)

What I have done so far is:

>do the usual procedure from the destination sheet A1 (='sheet 1'!B1) then go to the source sheet B1 (sheet 1).

But my problem is by doing this procedure it shows that the row (A1) is dedicated only to the sheet 1). What if I got additional source sheet, how can I sort my destination sheet?

Thanks