New Table from Existing Tables

[sub80]

Hi;

Looking for best way to do this task and somewhat foolproof, I have main workbook which should lookup data in multiple sheets from multiple workbooks and place the rows in which the lookup cell has a specified color.


Regards;