how do i import multiple large googlesheets, with multiple worksheets, and then integrate them?
I have inherited several google worksheets. each worksheet is stand alone, with about 20+ workbooks per sheet. the first several workbooks of each sheet are basically summary dashboards of the remaining workbooks. so there's lots of vlookups, sumifs and so forth. When I try to import, of course only the first sheet of each is coming over and formulas are not being preserved.
my goal is to: retire all the google sheets, create a summary dashboard and summary report, and actually link the workbooks together. ideas on how best to approach this problem are much appreciated! (btw: this is to help schools reopen post COVID, so any help is helping kids!)