Merging a large amount of data from multiple sheets
I am hoping I can get some assistance with this. We have a Work In Progress report that is currently housed in google sheets, but we are looking into moving it over to smartsheet. In Google Sheets, the report has 4 different tabs. All 4 tabs are in the same order (by project), but house different data on the project.
1 - Summary - this tab pulls all the data from the 3 other tabs so we can view it all in one place and is not editable from this sheet (only from the source tabs). This tab is 150+ columns x approximately 120 rows.
2 - Acct Mgr - this tab is what our account managers use to enter their input sheet data.
3 - Production - this tab is for the production team to track the progress of the project.
4 - Admin - this is the tab used in office for tracking of progress / other data on the project.
Since Smartsheet doesn't have tabs, I created individual sheets for each tab. The issue I am running into now, is for the summary sheet. It taps out at 20,000 cell link references so I am not able to reference all the data we need in there. I also tried doing it as a report, but it doesn't merge the rows together, instead it creates one row per sheet (which means I have 3 rows for each project to look at). Is there a better way to do this??