Unique list from various sheets listed text into one sheet

[mmr1]

Hi,

I need a formula to make a unique text list from various sheets data,

=UNIQUE(A2:A1070) used for make a unique list for one sheet,


Required a formula to make unique list from other 10 sheets in one sheet.

Thanks in advance,

A

Excavation for Retaining wall

Construct new base slab

Construct new wall - 56.5 m

Water proofing & Backfilling

Excavation for Retaining wall

Construct new base slab

Construct new wall - 56.5 m

Water proofing & Backfilling

Construct Retaining wall

Lay Proposed Modular Block and match with Existing Modular block Level & Tie in

Retaining Wall Construction

Lay Proposed Modular Block and match with Existing Modular block Level & Tie in