Create an index of records from multiple tables?

[Brown_Miller]

Hey, can anybody think of a way to create a table that consists of a listing of all the records in several other tables in an index format. Something like this:

Primary Field Value | Table Name

Bob | First Names
Goldthwait | Last Names
Comedian | Occupations

I want to produce a single table like the one above, dynamically and continuously from live data, from a base that contains the following tables:

TABLE: First Names
RECORDS: 1 Bob

TABLE: Last Names
RECORDS: 1 Goldthwait

TABLE: Occupations
RECORDS: 1 Comedian

This is just hypothetical data.

I know I could this by exporting to a spreadsheet and reimporting but I want it to be automated and real-time. Any ideas?

[Heidi_Anderson1]

I have the same question as we build out a digital asset management base. Assets will be sourced from various bases for example individual pics and company logos from our CRM, event pics from our events base, articles from our eNews base, etc.