Macro to consolidate data from multiple data from worksheets into on worksheet

[neilclelland]

I have a number of worksheets (n=202) which contain two columns of data, the first column is integers of density and the second a pixel count from an image. I would like to consolidate these columns into one single worksheet by column, but only including the integers in the first column and the pixel counts with the corresponding worksheet number as a header as the continuous following columns.

I have an add in for excel which will combine worksheets (kutools) but this combines the data rows so that data is on top of one another and I need it as columns so I can plot the results.

I have attached an example of the simple data file containing an example of the first ten worksheets if that helps

[AB33]

Your request is not clear. Try it and will adjust it.

[neilclelland]

Sorry if it's not too clear. That's pretty much perfect, although I don't need the integer count in every other column, only in the first column.

[AB33]

See if this is better.

[neilclelland]

No sorry, it's the other way around. The negative values are the integers for the density range. so I need this in the first column and the rest of the data in the following columns.

[AB33]

I have excluded all column B. I do not know which column B of all the sheets should be consolidated.

[neilclelland]

Column B in each worksheet is the data that I need consolidated and column A in each worksheet is the value of that data. So I only need column A copied once into the master (as the first column) and the rest of the column B's from each worksheet in order. Hope this is clearer now.

[AB33]

Okay! I got it right.

[neilclelland]

Great, works perfectly. Thank you, you were very patient.