# Multiple Sheets in one app

**URL:** https://community.glideapps.com/t/multiple-sheets-in-one-app/9441
**Category:** Ask for Help
**Created:** [May 19, 2020, 9:04pm UTC](https://community.glideapps.com/t/multiple-sheets-in-one-app/9441 "2020-05-19T21:04:01Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![Adviuz](https://avatars.discourse-cdn.com/v4/letter/a/b38774/32.png) [@Adviuz](https://community.glideapps.com/u/Adviuz)
#### Post date: [May 19, 2020, 9:04pm UTC](https://community.glideapps.com/t/multiple-sheets-in-one-app/9441/1 "2020-05-19T21:04:01Z")

</div>

**History:** As we are working on Building the sales, a user is working on multiple google sheets for multiple projects.

**Goal:** We want to show data of all sheets in glide app and common calendar for all sheets.

How to do this?

---

<div class="post-metadata">

### Author: ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [May 19, 2020, 9:16pm UTC](https://community.glideapps.com/t/multiple-sheets-in-one-app/9441/2 "2020-05-19T21:16:36Z")

</div>

@Adviuz Have you experimented with the [importrange() function](https://support.google.com/a/users/answer/9308940?hl=en) in Google Sheets or looked into [Sheetgo](https://www.sheetgo.com/)?

---

<div class="post-metadata">

### Author: ![Gemini\_Commercial\_Se](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gemini_commercial_se/32/11399_2.png) [@Gemini\_Commercial\_Se](https://community.glideapps.com/u/Gemini_Commercial_Se)
#### Post date: [August 20, 2020, 5:24pm UTC](https://community.glideapps.com/t/multiple-sheets-in-one-app/9441/3 "2020-08-20T17:24:23Z")

</div>

Good evening. Quick question.

I understand the importrange function however my issue is that my sheet is reaching the max number of tabs (200) and I need to start a new sheet however I need both to be read by the same app I have created. Is that possible?

---

<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: [August 20, 2020, 5:40pm UTC](https://community.glideapps.com/t/multiple-sheets-in-one-app/9441/4 "2020-08-20T17:40:59Z")

</div>

Unfortunately that’s not possible, only one source data can be specified.

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [August 20, 2020, 5:42pm UTC](https://community.glideapps.com/t/multiple-sheets-in-one-app/9441/5 "2020-08-20T17:42:12Z")

</div>

Can you explain why you have so many sheet tabs? Would it be better to restructure your data?

---

<div class="post-metadata">

### Author: ![Gemini\_Commercial\_Se](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gemini_commercial_se/32/11399_2.png) [@Gemini\_Commercial\_Se](https://community.glideapps.com/u/Gemini_Commercial_Se)
#### Post date: [August 20, 2020, 5:53pm UTC](https://community.glideapps.com/t/multiple-sheets-in-one-app/9441/6 "2020-08-20T17:53:23Z")

</div>

We have a courier service and each customer has his own sheet and with increasing customers we are reaching the limit

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [August 20, 2020, 5:59pm UTC](https://community.glideapps.com/t/multiple-sheets-in-one-app/9441/7 "2020-08-20T17:59:23Z")

</div>

Is there any way you can structure all customers into one customer sheet? If done correctly, they would only see their own data and you could add customers without the need to go into the glide editor each time to add and design a new tab. In my opinion, similar data in a database should be grouped together to allow for scaled growth without having to make changes to the app interface.

---

<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: [August 20, 2020, 10:24pm UTC](https://community.glideapps.com/t/multiple-sheets-in-one-app/9441/8 "2020-08-20T22:24:40Z")

</div>

That’s what we do now for a very big app. Have a company wall well built can let us scale well.

I have a company column in my user profiles and bring it everywhere else using lookups so that I can set the right filters/visibility conditions on other tabs.

It’s not easy but if you spend enough time it will work.
