combine many colums in one without duplication

[EngMarine]

Dear all

if i have many tables and each one in on separate sheet and lets say that they have values in 1st column like ppl names


i want to make one big table (in separate sheet) containing all ppl names inserted in all the tables without duplication

can i do that automatically ?


thanks and regards