vba code to extract data from data table and update data sheet

Hi All

I have a workbook with table 1 and data sheet .

the data sheet requires an index and match from column I of data sheet to table 1 sheet column A.

extract data from column C, D,E,F to paste to data sheet from column AS TO AW.

however if data sheet column K has SADC IN ROW 2 then INSERT header SADC IN AX 1, then put Y if there are sadc reference and adjust column AT on data sheet to 0.

otherwise if there is no sadc then put the rate as from table 1 sheet to 15 to datasheet from column D and put N IN COLUMN AT

Note the datasheet goes to 5000 to 20000 rows doing this manually is a true pain