You can use the Content Query web part in MOSS. It lets you configure
it to limit to display a certain number of items, which you could set to
"1". As the sort order, you could sort by "Modified" in descending
order. That way, it will display only the one most recently modified
document from a site or site collection.