We have 3 files. Config file, master file and input file.
Read the config file to get searchElement list column and output column (column name/index)
Use get workbook sheets activity to get all sheet names in input file.
3.Use for loop and read all sheets and add datatable to dictionary of type Dictionary(Of string, Datatable) along with sheet name as key
Read master sheet
Use For each loop to read searchElement. Inside loop check if SearchElement is present in Dict values (table1, table2…etc)
If SearcElement is present, get the Dict Key and update it to result column in master sheet
use break activity to check next seachElelemt in tables