Gathering data from 1000 sheets

Hello, i have this question:

We have more then 1000 sheets with some project progress calculated in certain cell. Then we have one master tracking sheet with 1 line = 1 project. What i need is:

  • Link this progress number from each sheet to every corresponding line
  • Use that number for further calculations (which is not a problem, but it also means we cannot use Report or Dashboard for displaying those numbers)

Right now we are linking those cells manually. Since using Cell linking was slowing master sheet down, we are using Cell reference as "=sum([cell reference])".

But then we hit the 100 cell reference limit, which is really bad.

Is there another way how to collect those numbers and use them for further calculations?

Any hint would be much appreciated 😎

Thanks

Daniel

Best Answers

Answers