Hi all,

I would love help on this as it is starting to melt my brain and will save me hours of edit-replace!

So here it is:

I have the same selection of cells in multiple sheets that I would like in one table on a separate (Master) sheet.
I would like to be able to copy and paste all of these in one go but I am struggling to do this. I have an extremely basic understanding of code..
The cell range is a rectangle comprising of N2 - S2/N80 - S80
This could be in up to 50+ sheets within a workbook.
Ideally these could be transposed from being displayed in columns to rows as well. i.e. N2 - N80 would read B2 - CG2 (if my counting is correct) and then O to S would then sit underneath.

It would be ideal if all the sheets within the workbook were just pasted in below one another:
i.e. the rows in the master sheet would be as follows (with all the data along the row):

A: Headings (I'll put these in last)
B: Sheet1 N
C: Sheet1 O
D: Sheet1 P
E: Sheet1 Q
F: Sheet1 R
G: Sheet1 S
H: Sheet2 N
I: Sheet2 O
J: Sheet2 P
K: Sheet2 Q
L: Sheet2 R
M: Sheet2 S
etc...

I really hope a) this makes sense, and b) someone can help. Like I said my understanding is very basic so simple step by step info would be great!

Cheers

TJ