Complex situation, expert needed...
 

I am trying complex linking project and was anyone knowledgeable to help
me....this is the situation....
I have 4 workbooks that I want to link to a 5th workbook to update the
sheets on that 5th workbook...here's where the difficult part comes in....
the 5th workbook conatins 4 sheets (wb5, sheet1, sheet2, sheet3, sheet4)
wb1, sheet1 - data changes in almost all cells daily...
wb2, sheet1 - same as wb1, changes daily...
wb3 - gets a new sheet added everyday with some existing data from the
previous sheet as well as new data...
wb4 - is actually a new wb everyday with same naming scheme, it contains 1
sheet only, in each new wb...
what I'm trying to do is update wb5 with "wb1, sheet1" to wb5,
sheet1....then "wb2, sheet1" to wb5, sheet2...then "wb3, newest sheet which
is always at the end of all sheets" to wb5, sheet3...then "wb4, new book with
same naming scheme" to wb5, sheet4....can anyone help me with this, or is it
just out of excel's abilities....thanks

To link to a sheet or workbook whose name is variable you could use the
INDIRECT function - but then the source workbook has to be open.
If that is not a suitable solution you could change the link sources in
an Auto_Open macro.

If you need further help, please indicate which type of solution you
prefer and give the names (or naming schemes) of the workbooks and
sheets concerned.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup