Macro to Copy Unique items i>e non duplicated items

I would like code to copy unique items in Col A on Sheets starting with BR for eg BR1, BR2 etc to Col A on sheet Total BR


I have manually done this to show you what I am trying to achieve


Attached please find sample data


It would be appreciated if someone could kindly assist me

Please Login or Register  to view this content.

Artik

Try this. In this example I write the data in column F to show you the output

Please Login or Register  to view this content.

And sorted:

Please Login or Register  to view this content.

Many Thanks for the help Artik & JEC

You're welcome!