Extract unique list from various sheets with combined unique and indirect function

[mmr1]

Hi,


could you please someone correct the below mentioned formula, as i am looking to extract a unique list from various sheets by using unique and indirect function and it is returns result as #VALUE!

=TRANSPOSE(SORT(UNIQUE(INDIRECT("'"&{"Sheet1","Sheet2","Sheet3"}&"'!A4:A37"))))


Thanks for the help

 

[Radoslaw Poprawski]

does it works as it should?
is there anything else?