VBA Sorting moving cell names

Hi, I'm looking to sort data in excel vba, I have a method that work (see below), but I noticed that it doesn't move the cell names, because I rely heavily on cell names, I need to be able to move them with the sort. Is there a way to do this?
Thanks

Please Login or Register  to view this content.

I'm working on an inventory list for machine fixtures. some of the fixtures have identical parts (say 5/16-18UNC x 1" socket head screw) when this happens I want the quantities to update in the different fixtures (so you can update any one, and the numbers for the identical parts will update The sheet needs to be dynamic because we are constantly getting new fixtures, and getting rid of old ones. I use the cell names, in the intersect function so that when a new fixtures is added (fixtures each have multiple rows) the cell name moves with it, and the intersect function always has the right cells. I have a worksheet that acts as a search tab. once it pulls up the info for a fixture, the user can sort the spare parts by part name, or a couple of other criteria. basically the cell names have to move, so the intersect functions don't get messed up. This is hard to explain.

I understand that a basic sort doesn't work for the above mentioned reasons. I have had success with a while not loop and cut paste. But this time I'm working with words not numbers.