An interface can only pull from one base.
However, you can sync views from other bases to a single destination table (or multiple destination tables) in a base. Then you can pull your interface from there.
However, note that the data will be read-only in your destination table, so that may be a dealbreaker for you. Also, when you sync bases, there is a maximum number of syncs that you can setup.
Your best bet would probably be to create your dashboard in another app — something as simple as Google Sheets or Microsoft Excel, or something as complex as Databox or Tableau — and then use Make to automate the sending of your data from Airtable to those other tools.
There can be a bit of a learning curve with Make, which is why I created this basic navigation video for Make, along with providing the link to Make’s free training courses.
Also, if you have a budget for your project and you’d like to hire an expert Airtable consultant to help you create this, please feel free to contact me through my website: Airtable consulting — ScottWorld.
