How to pull data out of an excell file with multiple tabs
 

I have 65 files with 20-40 worksheets in each file. I need to extract the
same range of data from all worksheets into a single Excel file.

Any ideas?

Record a macro while manually doing two or three files, then edit the macro
to accomodate all the others..........

Vaya con Dios,
Chuck, CABGx3


"mdeanda" wrote in message
...
I have 65 files with 20-40 worksheets in each file. I need to extract the
same range of data from all worksheets into a single Excel file.

Any ideas?