Excel 2007 Copy Multiple Columns into one

Hello,

I am trying to create a macro that will automatically copy multiple column lists into a single list. Let me clarify.

Sheet 1 contains three multiple column lists > List 1 is columns G through K, List 2 is columns M through Q and List 3 is columns S through W. Rather than have 3 separate lists, I want a single list, that contains all of these lists. In other words, Columns Y through AC would show Lists 1, 2 and 3. That way, I have one consolidated list (List 4), that encompasses all of these lists into one.

I have 6 worksheets in total, with 3 of the aforementioned lists. And in fact, if I could, I would prefer all 3 lists, from all 6 worksheets, to be combined into one master list.

Can you please assist?

Thank you!

Jon