Consolidate Worksheet Contents
 

Greetings to All!
I have a workbook with say 8 to 9 worksheets each containing multiple
columns not arranged the sequencially.

For Eg
Sheet 1 has the following Column Headers:

COMPOUND DESCRP LOOPID MEAS HSCI1 LSCI1

Sheet 2:

COMPOUND NAME DESCRP PERIOD PHASE LOOPID

Sheet 3:

DESCRP PERIOD PHASE LOOPID SIMOPT

and so on...

Now I want to consolidate all the contents of Worksheets under a Single TAB,
how do I go about it? Is there a macro Readily available?

On searching the forums I found a similar problem addressed by Mr. Bernie
Deitrick. But that didn't serve my purpose as it had a restriction of only 3
columns :(

Thanks a lot in anticipation ;)