I assume you have a separate sheet for each fund.

In your master sheet compile, in column A:A, the names of all the
worksheets containing funds. Say you start from A2 to allow for
headers. B2 will contain the shares and C2 the balance. In B2, C2:

=LOOKUP(10^307,INDIRECT("'"&A2&"'!B:B"))
=LOOKUP(10^307,INDIRECT("'"&A2&"'!E:E"))

For the last one I am not sure which column you consider the be the
balance, but change the column in the formula.

HTH
Kostis Vezerides

On Jun 7, 6:58 am, Jon Dow wrote:
I am keeping a running log of mutual fund activity. Something like this:

Date Shares Price Daily Total Gain/Loss
6/1/2007 503.30 40.53 20,398.83 0.00
6/2/2007 503.30 40.59 0.06 20,429.03 30.20

I have several funds like this. I want to take the most recent balances and
summarize them on another sheet. So in other words, when i enter in a new
days worth of infomation, the formula on the other sheet will automatically
pick up the latest information. Something like this:

Fund A Shares Balance
Fund B Shares Balance

Any way to do this easily? Also, would there be an easy way to maybe drop in
a date and have it pick up the information for that date? I am trying to
create Quicken or Money in Excel because those 2 programs can be SOOOOO hard
to use for this stuff. Thanks.