I would like to take data on one sheet and copy and sort it on another. I know how to do this manually, but don't know how to set it up to have it done automatically.

On one sheet I would like to take all the raw data from another sheet and sort it by value in a particular column.

On other sheets I would like to selectively copy data based on values of a particular column to the sheet and then sort it by value in another column.

If anyone knows how to do this I would appreciate the help!

Andy