Thanks again for your reply, i think i was not very much clear

what exactly i want to do is retreive data from 175 workbooks in a single
sheet

175 different workbooks in different sub folders -----to------ a single sheet

To confirm, file names are in same format i.e. Time Series xxx.xls, and in
the all workbooks worksheets name are similar as well i.e. Time Series the
only problem for me is to how to deal with different paths of subfolders.

175 companies are distributed to different persons who update informations
and that is also through a system (everything is purely in Excel). Data
structure for a company is as follows:

3 Folders 1. External Research (Market Research)
2. Financial Statements (Soft Copies of statement)
3. Internal Research (Internal Working + Time Series + write ups)

the way we are working different 175 workbooks are neccessary and already we
have don alot more so any change in structure would cost alot.

Main thing i want to do, if i was not clear before,

1) I have a list of all 175 workbook paths in a single sheet
2) I have to retreive value, as stated before, in the same workbook in a
another sheet, where i already have the list of workbooks path


In Sheet2
In Cell A1 the Co. Name (ACBL)
In Cell b1 the path of the time series for that co. (S:\Commercial
Banks\Askari Commercial Bank Limited\Internal Research\Time Series ACBL.xls)

what i was trying is " vlookup(a4,table_array,Col...........)

Instead typing the table array manually i am trying to link the cell B1 as
table_array
Is there any way ?

the same thing i tried to tell before, only the data is change, but if there
was anything different in working then pardon me for that


"Max" wrote:

It's much easier to work with 175 identically structured source sheets in a
single book / file than to work with 175 books, leaving aside 175 books in
175 different folders ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Salman" wrote in message
...
Thanks a lot, and pardon for that, infact after posting my query i could
not
saw my question on the forum nor i receive any intimation through mail
from
the site, although the first one was posted couple of days back, I just
received 3 intimations at the same time, dont know wat happened.
thanks for your effort, now i will go to your reply, i think its
neccessary
to thanks you first and now i am going to check your reply for earlier
post.
in recent post i try to clear the situation which i thought somehow
confusing, but the situation, i mean the action wat i want to do is the
same
and it can be use in any situaion if there is any solution.
Once again thanks alot