Your expert advice would be most appreciated:
Using Excel 2003, I want to sum the contents of cell A1 on the last active
worksheet of 22 other workbooks into cell A1 of a master consolidation
workbook. The active sheet in the 22 workbooks will change from week to
week, so I need the master workbook to only retrieve data from cell A1 in the
sheet that was visible when the other 22 workbooks were last saved.

I can put a formula in the master consolidatioin workbook to link to a named
worksheet in the 22 other workbooks but cannot get it to link to the cell in
the last active worksheet.

I hope this makes sense, and that you can assist.

Regards