Excel row sorting question

Hello,

I'm a very basic excel user. I am trying to create a workbook that has seperate sheets that track different things for the same people. I want to have the firts sheet populate the rest of the documents. I can make this happen, but I also want to be able to sort on the first sheet, or any for that matter and have each row keep the original information.

I've done a few google searches, but can't find what I'm looking for. I'm probably not using the correct terminology.

How can I make this happen?

Thanks,

Mike