I need to be able to amalgamate the data from four (soon to be more) identical lists.

One of the lists resides on the client's internal SBS server and the other lists reside on a number of sub-sites of an external hosted WSS site. The client uses these lists to collect lead information from associates and internally.

For reporting purposes they would like to amalgamate the lists into one "super list" which they can then slice and dice as they like either with different views or in Excel.

I've had a look at the Using Microsoft Frontpage 2003 to Customize SharePoint Products chapter in Bill's book which gives an outline of how to do what I want to do, but I can't see how to get the lists from the external hosted site to appear as Data Sources. Is that possible?

Is it also possible to merge list data into one new list which is effectively what I want to do.

Or is there a better way?

This is WSS, so none of the SPS bells and whistles are available.