Madhan
Yes, VBA can do this, but why do you not want the other workbooks
opened? Do you mean YOU don't want to open the other workbooks manually or
do you mean that you don't want VBA to open them either. VBA can open each
book, get the data, close it, open another book, etc. and you would not see
any of it happening on the screen. HTH Otto
"vmadan16" wrote in message
...
Hi All,

I need help.. I have an excel file called as Main Det. I need to update
this
file with Datas from more than 10 other excel Workbooks. The complication
in
this is the Main Workbook has 5 sheets and all other workbook also has the
same number of sheets and each sheets as 20 rows of data. and what I want
is
Subworkbook sheet1 data to be updated in Manin Det sheet1 (for example:
data
from workbook1 sheet1 and the the range of the other workbooks changes (1
column increases every week). Is there any way of doing this using a VBA
and
without opening the other 10 workbooks.

Please let me know if I am not clear or confusing.

Thanks in Advance

Madhan V