I enjoy that kind of Project. Unfortunately my main computer is broken and this little laptop just is not good enough to work on a large project.

I would like to see the entire file, but I would only want to see the data and calculations for 3 orders and 3 factories.

So for every analysis that a user will do like changing the minimum qty per day or changing the efficiency of the specific dept he will have to wait 12+ 65 = 77 secs to see the analysis results which is very time consuming.
that is why the data should be organized for Excel and not for people. Reports and result should be organized for people.

Excel must look at the entire sheet and calculate everything on the sheet. If you have a sheet for each factory, only that sheet and the results Report sheet need to be calculated.

In programming your project is known as 'organic,' meaning that it started small and manageable, but over time more and more was added to it until now it is no longer manageable.

In my experienced opinion, it is time to step back and look at what you need, without considering what you have, then design a Project from the ground up to accomplish that in an efficient manner.