Combine contents of a column

[Patrick C. Simonds]

This is what I would like to do, could someone tell me if it is possible.

I have 4 worksheets, in column B of 3 of those worksheets the user enters
names of clients. On the 4th worksheet I would like to create a list of each
unique name ( so if there were 5 instances of Bill Smith I would like it
listed once) based upon the contents of column B of the first 3 worksheets..

 

[Barb Reinhardt]

You can do this fairly easily with a pivot table, or do you want a VBA
solution?

 

[Patrick C. Simonds]

I think that a Pivot Table might be the way to go. Having never used the
Pivot Table feature I will have to do a little research on how to do that.