Your statement that it involves tables is just about perfect.

Here we go (I have XL2007 so you might have to look around in 2003)
Assume you have a workbook called MySource
Sheet1 has a table (A1:G10), where A1:G1 are headers
Sheet2 has a table (A1:G10), where A1:G1 are headers

In your Target Workbook
1) Get external data from access
2) Cange the filetype to all and select the MySource.xls
3) Automatically you'll be promted with "Table Select"
4) Select Sheet1, Next
5) Go into Properties (change update interval to your preferences)
5) Press OK

Now you'll have the "Table" in your sheet and it it updated according the settings you made (every XX minutes or when you open the WB)