Working within an Excel Workbook, I would like to create a separate
worksheet where the data in one worksheet is listed in another
worksheet if a condition is met (i.e., if the project name in column A
= Smith, all rows pertaining to Smith will transfer to another
worksheet titled "Smith".  For example, my main worksheet has rows of
information by Project name.  I want all rows of data for a particular
project to be listed in a new worksheet which I can set up and name by
Project.  This way I have one primary spreadhseet with all my projects
combined into one worksheet and additional worksheets that
show only the rows of data for specific projects.  

I need to know what formula or steps I need to take in order to gather
the data from my primary worksheet and create sub-worksheets by
project.

OR - Is it better to enter data in individual worksheets and then have
all the worksheets roll up to the "primary" or master worksheet.  If
so, I need to know how to do that.  Thanks for your help.

The easiest way to do this is:  

1) Name each sheet.  I named them "Roll Up", "Smith", "Jones"...
2) Enter all the data in the Roll Up sheet.  The name should be in
column A and any information associated with the name should be in
B,C,D...
3) In sheet Smith, type this formula in B1: =IF(Base!A2="Smith",Base!B2, " ")
4) Copy that cell down and to the right far enough so that it will
capture all the data in Roll Up.
5) Use this same formula in the other sheets but change the name in
the formula appropriately.

This approach will leave blank rows in each of your name sheets, but
it will capture all the data.  This approach also requires you to
manually make and set up a sheet for each name in the list.  This
could be avoided with a more complicated method.