formula for converting info in a column into a list...

I hope no one has already posted this question and i'm just not bright enough to find the thread!

Basically, I have a client and project database which I update constantly. I do everything manually now, but it's just too time consuming and I know just enough about formulas in excel to impress someone who has never seen excel. This one is beyond me.

Worksheet 1 has the projects and pertinent information (because that is updated most often).
Worksheet 2 contains info about materials which come into the shop in reference to the projects.
Worksheet 3 contains contact info for the clients.

I'm using a simple list manager workbook to take care of most of the information.

On worksheets 1 & 2, there is a "client name" column on which I use a list wizard function to simply chose the name from a drop-down menu. I want the "client name" column on worksheet 3 to be a master list of my clients for those other worksheets.

So, again, for my own brain, how would I craft a formula for the "client name" columns on worksheets 1 & 2 to access the names from the "client name" column on worksheet 3 and use them as the "list"?

...if that makes sense.

Perfect, the first link was exactly what I was looking for, thank you!