I have a worksheet with a list of random phone numbers in column A. The
numbers are repeated a number of times. For example, there may be 100
entries made up of 15 numbers. I would like to be able gather those 15
numbers and list them on another sheet in column A.

Example:
Sheet 1
A
A
C
B
C
D
B

Sheet 2
A
C
B
D

Any ideas.