I am planning on using data partitioning to be able to select different spreadsheets (from smartsheet) from an Enum list. What type of partitioning do I use, across many files/sources or across many worksheets? The spreadsheets will be constantly gro...

I need to have the user switch between data sources. How can I do this? There may be many sheets to select from and if we put all the data in one sheet, it will get enormous. We are using Smartsheet.