Consolidating/summarizing and sorting data
 

I hope I can explain things well enough to avoid wasting your time. I expect
my explanation will be longer than the solution.

The workbook has several worksheets but lets say there just 3, namely
Summary, ThisYr and LastYr. The last two are identical in layout. They have
5 formatting rows at the top and data proper starts at row 6. Each row
relates to one customer and the early columns have name and contact info and
later columns contain sales data. It is quite ordinary stuff really. The
only real complication is maintaining the date - inserting rows for new
customers disrupt formulae on the Summary sheet.

My question relates to the Summary. There isn't a correspondence of rows.
Each customer has structure 5 rows tall. For example, one row relates to the
current year and another row to the last year and each uses formulae to
derive percentage changes etc from the other worksheets. The Customer Name
is pulled from other sheets as well

I need to sort this entire 5 row structure according to differing criteria
within this structure such as
Customer Name [top left of structure (say R1C1)]
Value of Total Sales this Month [R2C(14+MonthNum)]
Value of Sales this Year to Date [R3C(14+MonthNum)]
Increase over last year [R5C(14+MonthNum)]
Value unpaid [R5C8]
etc.

Is there a technique to use that will not scramble the formula references on
Summary? In other words, having sorted, can I be sure that the data showing
against George's name is really his data and not Bill's?

T I A
Len