Hi everyone,

I am trying to take 20 excel files with single worksheets and import this
into a central workbook containing all the worksheets. And know I do not
want to cut and paste these in by opening each file one at a time to do this.
I need to run a program to do this all at once because this will eventually
be in excess of 60-70 excel files I need to do this with. Worksheet name
should carry the filename (minus the .xls). I plan to import these.
Manipulate the data and then export back out to individual forecast files. I
have the export program figured out. Import has me. Does anyone have a VB
program that can do this?