to first question DATA column AW takes values from TABLE 1 column O , yes .

2)no , at row 2 there may be no sadc, as there may be loops , that is row 2 no sadc to row 5 , then row 6 sadc , then row 7 no sadc , row 8 to row 50 sadc , row51 to 150 no sadc , then row 152 to row 350 sadc and so on .it's uneven and go up to 1000 rows or more

So data sheet check column I with table 1 column AA, THEN check K2 (DATA SHEET)TO, IF there is sadc in row2 then data extract from table 1 column D , E , F ,I and O but inserting SADC header at a AX.

So to my opinion it should check first column K sadc header of data sheet up to last data row , if there is sadc eg row 50 , then it should insert the sadc header at column X , then process

So if there is no sadc in column K of datasheet to last data row then d ont insert header sadc at column AX but extract data from COLUMN C, D,E,F and O of table as it is .

So if only there is sadc is column K datasheet that it should insert sadc header at column AX , put Y if sadc and N if the row is blank