Sorting on multiple worksheets in Excel
 

I need what I sort on page one to sort on the page I have it linked to and
carry over all information. It sorts on the linked page what is in a
specified column only even though I highlight all the information to be
sorted from page one. It sorts all information on page one to include the
numbers in the corresponding columns which are highlighted, but on the linked
page, it only sorts the names in the specified column and doesn't move the
numbers in the other columns with it. Is there a way to lock the rows
together or get them to sort the linked page?