Mincus1308, thank you so much for your reply.

if found: you want to copy their contents into a new workbook (new workbook every time? or just on workbook for all of the found columns?)
This should be only one workbook, and everything should fit into column A. Let's say from first file, we find 50 values, those should be pasted into column A, then second file has 30 values, it should continue through column A where the next empty cell is like A51, etc.

Thanks again.