Excel 2007 : Auto Sort Multiple Tables of Data in One Sheet By a Column of Numeric Values

I have a worksheet with a list of products in different categories:

Rows 2 - 71: Cakes
Rows 73 - 178: Muffins
Rows 180 -203: Croissants
Rows 205 - 215: Cinn Rolls
Rows 217 - 220: Pastries
Rows 222 - 223: Danish
Rows 225 - 234: CinnaTwists

The number of products in each category will change over time, as new products are added, so the above is simply the current configuration. All cells contain formulas to other worksheets within the workbook, so the values can also change. Corresponding data on each product extends out to Column BQ. I need the sheet to automatically sort the list of products (and their corresponding columns of data) within in each category by their weights, from low to high. Can this be done and, if so, how do I make it happen?

Alternatively, I could sort the data prior to this page, when it's in a more simple format, which may be easiest. I still would need advice on accomplishing this task, though.

Thanks,
Grant