Hi,

I have a worksheet with information on money held by 20 different people. In
each sheet (1 per client), I have inputed valuations for each month.

In sheet 1, I want to see at a glace the latest valuation per client, but
this needs to be linked to the date, so that it generates the valuation
corresponding to the latest date.

Any ideas?

Thanks in advance.