Sorting

I am new to the Forum and if possible can help someone help me with a question. I have a master spreadsheet that I sort column "A" for payroll. I would like to make a copy of that same spreadsheet and have it sort for Column "B". I have no problem populating the second spreadsheet from the master. My question is as I enter data on the master can I get the second (copy) spreadsheet to sort column "B" automatically (A to Z) without having to go up and highlight and hit the sort button??? Thanks in advance.