Converting 1 set of columns to 2 sets or more: Example Attached

Hey that's cool, but I need the formatting copied over (Critical part), it needs to be on a specified worksheet (in this case sheet2, but it might be called something else and start at a specified location B2 or c3, etc)...also when I typed in 3, I would have expected Rob and GE under J&K (set 2). Shouldn't the previous column be full before it moves to the next?

Thanks so much, a cool approach!

One other problem, I just noticed that when you enter 2, 3, or 4 it is sorting to the right and not down...can that be fixed?