jonastiger
1) "KS*"-values from Table1 to Table2 ...
... but ... how many "KS*"-values can You see?
2) with a sample Excel-file, something else could be possible to do.
An alternative option is use Power Query. Any additions to the tables would automatically be updated in the result when "Refresh" Icon is clicked. Look at this file. This is available to you if you have Excel 2010 or later.