Hi all,

I currently have have 13 sheets with data from C6-R6 rows through 6-9 columns. The data is in the same cells throughout the 13 sheets and I need to copy the data from these cells into a new sheet. Each column represents a different subject, and I would like to make each subject their own sheet. If I can't do that, at least have all the same data into one master sheet.

The 13 sheets have all the same subjects in the same order and the same cell corresponding data. I also want to change the format of the cells into the new sheet. I want to change the data from two columns to one row for each subject.

For example, this is what the data looks like right now:

Sheet 1
C D
Subject 125 Subject 265
Subject #1 Subject #2
Type 1 1800 (C6) 1600 (D6)
1400 1200
Type 2 1700 1500
1800 1600

This what I want the data to look like in the new sheet:

Subject 125

Type 1 1800 1400
Type 2 1700 1800

And have each subject on a new sheet.

I've tried using the indirect function but wasn't really sure how to proceed with that.

Thanks y'all!!!