Greetings,

I am working on a project that has 4 seperate excel files. Three of them have all different data, while the fourth one needs to be a listing of every entry in each of the other three. These need to continuously grow, so a simple drag down will not work.

Also, once it has grabbed every entry, it needs to be sorted by one of the columns that it has populated.

Ideally, I want to be able to grab only two columns from each, they will be the same columns, out of a possible 8 columns that have data in them.

Also, each file will have approx. 7-8 worksheets, and I need information from each of them.

Any ideas?

Thanks in advance,

Jordan Trulen