# How to link the tabs in spreadsheet?

**URL:** <https://community.glideapps.com/t/how-to-link-the-tabs-in-spreadsheet/10737>\
**Category:** Ask for Help\
**Created:** [June 12, 2020, 3:44pm UTC](https://community.glideapps.com/t/how-to-link-the-tabs-in-spreadsheet/10737 "2020-06-12T15:44:46Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Girish\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/girish_shah/32/5449_2.png) [@Girish\_Shah](https://community.glideapps.com/u/Girish_Shah)\
**Post date:** [June 12, 2020, 3:44pm UTC](https://community.glideapps.com/t/how-to-link-the-tabs-in-spreadsheet/10737/1 "2020-06-12T15:44:46Z")

</div>

I would like to link one tab data to another tab. This another tab could be dashboard where I can see top 10 sales and most recent sales. I am doesn’t create this kind of stuff before so can any one help me out how to do it?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 12, 2020, 3:51pm UTC](https://community.glideapps.com/t/how-to-link-the-tabs-in-spreadsheet/10737/2 "2020-06-12T15:51:05Z")

</div>

If you’re talking specifically about top 10 sales then you can use a QUERY to achieve it.

For the most recent sales, I believe this can be done with a rollup column inside Glide.

---

<div class="post-metadata">

**Author:** ![Girish\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/girish_shah/32/5449_2.png) [@Girish\_Shah](https://community.glideapps.com/u/Girish_Shah)\
**Post date:** [June 12, 2020, 4:00pm UTC](https://community.glideapps.com/t/how-to-link-the-tabs-in-spreadsheet/10737/3 "2020-06-12T16:00:19Z")

</div>

Sorry but, I can’t understood please explain in details - how to use the QUERY and rollup feature.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 12, 2020, 4:04pm UTC](https://community.glideapps.com/t/how-to-link-the-tabs-in-spreadsheet/10737/4 "2020-06-12T16:04:21Z")

</div>

For the QUERY part, you can read this article:

> **[Google Sheets Query function: Learn the most powerful function in Sheets](https://www.benlcollins.com/spreadsheets/google-sheets-query-sql/)**
>
> Learn how to use the super-powerful Google Sheets Query function to analyze your data in Google Sheets. Includes template.

Specifically the part about ORDER and LIMIT.

If you want to grab a basic knowledge about it first then I have written about it here:

> [@Tutorial - QUERY: "The most powerful function" in Google Sheets (part 1)](https://community.glideapps.com/t/tutorial-query-the-most-powerful-function-in-google-sheets-part-1/10432):
>
> This topic was inspired by our last community meetup, in which we talked about some formulas in Google Sheets and some people want to know more about QUERY, which was branded [“The most powerful function in Google Sheets”](https://www.benlcollins.com/spreadsheets/google-sheets-query-sql/) by famous GSheets teacher Ben Collins. So, what is QUERY, and why is it so powerful. Here’s a writeup on it, which hopefully would help many of you here in this community. Trust me, it would change so much how many of you “clean” your data in the future from raw data, in a very…

For the rollup column, I believe you can rollup by “Latest” using the datetime column.

Here’s the documentation:

> **[Glide Docs](https://www.glideapps.com/docs)**
>
> Welcome to Glide Docs, a steadily growing collection of articles and videos on how to use Glide. We can’t wait to see what you build!