How to build table of references to other tables

[Glenn Weaver]

I need to call specific fields from different tables, and save the list of calls for future use. The calls are in a specific order.

For example, I have 4 tables. I need to call items 1, 3, 5 from table 1, items 2, 3 from table 2, item 7 from table 3, and items 8, 9 from table 4.

The items need to be in a specific order, and save the list of items in a table for future use.

How do I do this?

Thank you for your help!