Hello Excel Forum,

I have 60 different workbooks (60 Health Centers) which have score data and comments for every score.

The score data is found on column C3:C18 and the comments are found on column K3:K18. What I would like to do is to automatically transfer and transform that data onto one master workbook in the following manner:

Opening the first workbook
The score data for on C3:C18 to be copied to A1, C1, E1, G1..etc on the mastersheet
The comments on K3:K18 to be copied to B1, D1, F1, H1...etc on the mastersheet

Opening the second workbook
The score data for on C3:C18 to be copied to A2, C2, E2, G2..etc on the mastersheet
The comments on K3:K18 to be copied to B2, D2, F2, H2...etc on the mastersheet

...etc

Can anyone help?

Thanks