Dynamic Macro's

I actually found a way to compile the entire list on one sheet. What I did was create a master sheet, and for every new row that is created on each aisle sheet, it makes a pointer to there respective cell in the master sheet. I have attached a text document containing an example of one of these workbooks. If you change the extension to xml or xls and open with excel, you will see the end result I was looking for. I had to shorten it considerably, because of the file size limitation on this forum.

Being able to do this has solved the majority of my problem. As far as I'm concerned, our users can sort there own work. But I am still curious to know whether or not Excel macro's can use dynamic variables to represent specific items. This would be an extremely useful tool, as dynamics are a key part of data processing.