Need Macro to combine columns from multiple sheets together in a new sheet

On occassion I have a need to combine all columns from multiple sheets into one new sheet within the same workbook for comparison purposes. Ideally, I need the columns to be combined in a "zipper" fashion. So, if there are 3 sheets, all ColAs would be the first 3 columns in the "combined" new sheet. All ColBs would be the next 3 columns, and so forth.

The number of columns, as well as the number of sheets, varies.

Attached, in the "Desired Result" tab, is a rudimentary example of what I am looking for.

Any help is greatly appreciated! Thank you!

Maybe:

Please Login or Register  to view this content.

John - this does exactly what I needed! Thank you very much for your help!!

You're welcome. Glad to help out and thanks for the feedback. Please comply with the Forum Rules and mark this thread as solved.

http://www.excelforum.com/forum-rule...rum-rules.html