I have a file which has the below sheets with data sets in the below columns.
The data sets in each sheet is in different column.
Sheet Name Data set 1 Data set 2 Data set 3 Data set 4 Data set 5 Data set 6
Os_sheet 1 A3:A1000 I3:I1000 U3:U1000 J3:J1000 K3:K1000 AH3:AH1000
ir_sheet 2 D10:D1000 F10:F1000 C10:C1000 H10:H1000 I10:I1000 AL10:AL000
IR_Sheet 3 D19:D1000 F19:F1000 C19:C1000 H19:H1000 I19:I1000 AM19:AM000
Op_Sheet 4 D26:D1000 F26:F1000 B26:B1000 E26:E1000 G26:G1000 BB26:BB1000
Need a macro which will pull the data from the various sheets and column ranges in to new sheet. This new sheet should be created as part of the macro
The data pulled by the above macro should be copied one below the other.