One thought which assumes that the most recent date & corresponding price in
the fund sheets will always be the data that's in the last filled row
(chronologically filled down)

For example, in the respective fund sheets (all sheets identically
structured), assume you have this kind of set up, dates in col A, prices in
col B, data in row2 down

In: Fund1
Date Price
1-Dec-08 10
1-Jan-09 20
etc

In: Fund2
Date Price
15-Dec-08 80
3-Jan-09 70
4-Jan-09 71
etc

Then in your Summary sheet, you could set it up like this
"Fund" sheetnames listed in B1 across, viz: Fund1, Fund2, ...
Labels placed in A2:A3: Most recent date, Price

Put in B1:
=LOOKUP(2,1/(INDIRECT("'"&B$1&"'!A2:A100")<""),INDIRECT("'"&B $1&"'!A2:A100"))

Put in B2:
=LOOKUP(2,1/(INDIRECT("'"&B$1&"'!A2:A100")<""),INDIRECT("'"&B $1&"'!B2:B100"))

Copy B1:B2 across as far as required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Don" wrote:
I am developing an excel workbook to track retirement funds. Each worksheet
represents a separate fund. The last worksheet contains a summary of the
various funds including latest unit price, number of units, etc. From each
worksheet (fund) I want the workbook to find the most recent entry (from the
date column) & corresponding unit price (from the price column on the same
row) & transfer this information to assigned cells in the summary sheet.
What function/programming is required to make this work?