Copying DataList Rows

First - I'm very new to the Excel programming/VBA environment...

I'm working with Sharepoint (WSS) 2.0 and have created an Excel
Workbook with several Worksheets. Each sheet contains several lists
(all having the same format) which are linked back to a Sharepoint
list/datasource.

So far I've figured out how to programatically keep all of the lists in
the Workbook synchronized with the Sharepoint list (via a VBA Macro).
What I'd like to do now is to be able to create a "Master" Worksheet
and copy all of the rows, from all of the lists, from all of the
Worksheets to create a Master copy of all of the data (and
ultimately/simply keep the Master also synchronized).

The master copy would then become the working copy of the data for
filtering, creating address labels, etc.

Can anyone point me to some existing/available VBA scripts that might
help with this?

Thanks!
Glenn