Is it possible to create one UX view sourced from 2 different tables?
for example I created a table view from one tab of an spreadsheet, now I want to link to tabs to the same view because I have both different headers and information on those tabs…
Try a dashboard.
Create your views, like you said, then create a dashboard that combines them together.
Use dashboards, but the form view is not available.