In MS Excel 2002: I have about 600 workbooks with 5 worksheets in each. To
gather specific information into one spread sheet I want to pick one cell
value from each(Sheet1, Sheet2, Sheet3, etc.) and paste into a column for
each sheet, one row for each work book. Each work book's name include a date,
so the link address to the cell can look like: =[Test040901.xls]Sheet1!$B$5
The date and the sheet number are the only differenses in the link addresses.
Instead of manually going into each linkaddress to change the date, is there
a way of 'copying' in a date from another cell to be part of the link address?