Hi Johnny,
I have a similar problem, can I send you my sample files. Briefly my problem
is like ..
I want to combine sheets such as advance(sheet1),deposits(sheet2),
creditors(sheet3), so on...Sheet names are unique. In advance sheet
validation must be done at h column starting row 6 for value & grab the row
until value = "LLINE" or BLANK, similarly it should check value in g column
for deposit sheet, i column in prepaid sheet, & so on... The consol file
should have sheets advance, deposit, prepaid, & so on with data from all
files.
I am using excel 2002.


"Johnny" wrote:

If the files are formatted in a fairly consistent way, I suggest either
writing an addin, or create a "master" workbook that goes out and grabs
the files (maybe in a specific folder, or by using a File dialog to
pick the files individually) and then pull them all into a new
workbook. The code here could get fairly involved, depending on what
the spreadsheets look like. If you want, you can send me a couple of
the workbooks and I can shoot you back an example. My email address
should be provided in the header of the post under view profile.

Thanks,
Johnny