Dynamic Macro's

I've kind of run into a dilemna. I work for a large hardware retail company as a programmer and PC tech. I've recently built a program that will allow salesman to build a list of items. It will then take the data, add more information to it and export it to excel.
Well, the problem is this: The worksheets are based around the aisle's in the store. People are picky and don't want to print out seperate sheets for each aisle.
I've basically been trying to learn VBA for Excel so I can write a macro that will run a sort on a specific column (sorting all columns in order) on each sheet. That alone would do the trick, but I would also like to know if there's any way to compile all the data that was sorted to the top of each sheet to an individual sheet.
Since my knowledge of Excel VBA is almost null, and I really don't want to have to go back and tear apart 980 lines of code, I would greatly appreciate any tips or pointers anybody has to offer.

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.

My apologies

Also, thought I would note that the block of code I posted is actually very sloppy. I won't bother to post my revised version.

when i was learning vba i found it very useful to record a macro of what i was trying to achieve on my sheet, eg grab some cells, dump them on a new sheet and sort them out.

just use
Tools>Macro>Record new macro

do your thing
click the stop botton
then in vba inspect the most recent Module for instant code.
its often sloppy, but at least it works. also i have a great pdf for easy vba coding. pm for a copy

cheers
pete