worksheet B has several cells that reference values from worksheet A. i'd like to make worksheet A a list, because it would make looking at different groupings on the sheet easier. however, if i reorder sheet A the formulas for sheet B are now not going where i would like them.

any ideas for how i might be able to have sheet B update the formulas?