Auto sort & save
 

I have a work sheet that I regularly sort by different columns and then save
that version. I'd like to have the data from my master sheet auto sort to
these new sheets. For example, the master sheet has customers, buildings,
orders and vendors. The master is saved chronilogically. I'd like to auto
sort by building to one sheet, by customer to another sheet and so on. I am
using Excel 2003. Thanks.