Sharepoint List of Sharepoint Lists

[cfoye130]

I have an access database that pulls in a sharepoint list (we'll call this the master list) that contains a list of hyperlinks to other sharepoint lists (child lists).

I am wondering if it is possible to run a macro to use the child list locations, listed in my master list, to create new tables containing the data in each child list. I would then need to export these child lists to a location, and then delete the tables.

I need to do this with a macro because the number and locations of the child lists are always changing, and the only place where those locations are known on a daily basis will be the master list.

Any ideas?