Is there an easy way to combine many excel workbooks into one new
one?  In a perfect world, what I'd like really is only the first 6
columns of each workbook.  Here's what I have, an active employee list
that is run each day.  They are saved with the current day's date, for
example today's is: 06-15-07.xls.  Each workbook contains roughly 1600
rows.  Each column has the same headers in each of the files.  If it
were easier, I could combine all columns, then once combined delete
the one's I don't need.  Any ideas?