Hi everyone,

I've referred to this forum for help a few times now, but this is my first post. Here goes...

I've got a folder with approx 25-30 files in it. Each file is a list of clients (1 per row), and I've manually gone through each list and color coded the rows based on client status. What I'd like to do now is create a "master" workbook for this folder, with each sheet in the master dedicated to a color. That way I have one central place where I can see all clients with the same status for the month.

So, I guess my questions are:
a) Is it feasible to do an import from this many sources?
b) How do I filter the import query based on row color?

Thanks for your help!

Jack