Hi, if thats an easier way to work it then yes
I assumed having the data scanned into sheet1, then the macro running on the active sheet, sorting all data into the right format and keeping it all on sheet1 would help keep the work book clutter free.
My sample was loaded on different sheets only to show what i start with, what i had worked on so far and what i wanted to happen at the end of it.