Consolidate data from different columns

We would need to know the names of the sheets from which you want to copy and the name of the destination sheet as well. How do you want the copied columns arranged in the destination sheet, beside each other or underneath each other. It would be easier to understand what you want to do if you could attach a copy of your file with a detailed explanation of what you want to do.

Try:

Please Login or Register  to view this content.