Creating Live list of names referencing seperate data sheet

Currently we have a tab that we will refresh with new data on a weekly basis. My goal is to have a separate tab that will automatically list the names of the people referenced in a singular column pasted into the data tab.

Further Detail:
We do manual researching weekly by pivoting the data, but to automate our process and compare the data to other queries we will need to stay away from pivot tables. Is there a formula i can use that would automatically have the unique list from a stationary column in the data tab?

Edit:
Adding excel sheet for example Apologies for missing that. First time posting

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.

Either:
=UNIQUE(TOCOL('Pasted Data From Query'!A2:A20,1))

or (if you want them sorted):

=sort(UNIQUE(TOCOL('Pasted Data From Query'!A2:A20,1)))

Change the 20 to whatever you need, but don't go mad and set to 000s if you only have 00s