Welcome to Airtable!
It’s hard to give specific steps without knowing your application in more detail, but in general you’ll be making use of linked records. If the fields you mentioned are in your main table, and your secondary tables are linked to the main, you’ll use lookup and rollup fields to access those values by reference. You can also use lookup and rollup fields in your primary table to retrieve values from other linked tables.
Values accessed by reference can be used in calculations in the retrieving table — that is, a formula field in a secondary table can incorporate a value looked up from the primary table in one of its formulas — but the results of that calculation cannot be used to change the value of the original field, as that could represent a circular reference.
You can chain linked records. For instance, a [Company] table might contain a linked record field called {Contact} that links to [People] table, which in turn could have fields called {Mailing Address}, {Office Address}, and {Home Address}, all three of which might link to an [Address] table. In that case, one might have in the [Company] table a {Contact Home City} field that would lookup the value of {People::Home City} that in turn would be a lookup of the {Address::City} field in the [Address] record linked by {People::Home Address}.
If you run into specific issues building your base — and there are a couple of potential ‘gotchas’ inherent in working with linked records, primarily resulting from a looked-up value being of an unexpected type — don’t hesitate to ask!
