I have the same selection of cells in multiple sheets that I would like in one table on a separate (master) sheet. I dont mind if this is within the same workbook. The cell range is a rectangle comprising of N2-S2/N80-S80. I would like the data to be transposed from being in columns to being in rows, pasted one below each other i.e. The master sheet would look like this: A = Headings, B = Sheet1 N, C = Sheet1 O, D = Sheet1 P, E = Sheet1 Q, F = Sheet1 R, G = Sheet1 S, H = Sheet2 N, I = Sheet2 O etc… I hope you can help, this would save me days of work!