Hi @Rana M
In your specific case, what about using a Report? A Report can do exactly what your diagram represents: bring together multiple sheets in one place. Ensure your column names are the same across your sheets, then all your data can appear in one Report together.
I like to think of Reports as open windows into the underlying sheets. This is because it's not housing the content itself, but it's allowing you a window into a row that exists somewhere else, meaning that if you make an update to a cell in a Report, that update will happen on the Sheet! And if the Sheet is being updated, the Report will show that automatically. It also means that your Conversations panel will show all the comments from the underlying sheets as well.
Here's more information:
https://help.smartsheet.com/learning-track/onboarding-webinars/smartstart-reporting
Cheers,
Genevieve