Textjoin for multiple sheets without duplicate value

hi
yes, i m using 365. but my colleague is using excel 2016 and excel 2019.. so basically i need to use those old version of formula, so that they can read/view as well