Hi Barbara
Thank you for posting your question in the Lucid Community! Unfortunately importing multiple sheets from Google Sheets at one time is not supported in Lucidchart. When importing data from a multi-sheet document you'll be asked to select which sheet you'd like to import.

However if you'd like to divide your Org Chart by team you can add a team column to your data set when setting up your Org Chart data. To learn more about how to set up data for Org Charts please check out this Help Center article.

We're always looking for ways to improve Lucidchart and your feedback is the best way for us to do that. Would you mind adding your idea to our product feedback space? Ideas shared here are passed on to the product development team for their consideration.
My apologies for the inconvenience and thank you for your feedback!