I currently have a worksheet in Excel 2007 where I have groups of data in rows (names, addresses, and number data columns) that I have summarized in a single row, and if I click on the name it takes me to a separate worksheet where all the rows of data are expanded. What I would like to do is to be able to retain that summary row in the main worksheet, but be able to expand that to include all the underlying rows of data (in the main worksheet, not a separate one), so that they can be part of a sort of data for the main worksheet. Right now, I have to sort each worksheet separately and then manually add them together.

Hopefully this makes sense. I've attached a copy of the spreadsheet if that would be helpful (trying to sort all the rows with the colored font for all worksheets)Mainstem WW SW Rights-GFID Project.xlsx. Thanks in advance for any help you may be able to provide!