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