I need to populate different worksheets from a source worksheet.

[Roy]

My source worksheet contains all communities in our division. Each community
has a specific #. Im trying to populte individual community worksheet from
the source worksheet by using the community #. Can excel 2003 do that?