How to Load formula from another category?

Hi, I tried everything. But can't get it to work. I want to load a category formula into multiple other categories. This way I don't have to replace every category and can I still make changes in the placement of the text. The formula needs to find the code of the page where it's loaded in.

For the category text I use this code: =Category1!E2 and that works. But the formula will only load in the result of the code. When I load it in as Formulatext or as Formula the code stops working. How can I still load in the formula? Thank you

Please read the yellow banner at the top of this page on how to attach a sample workbook.

I've attached an example. Don't know if it matters if the excel is in another language, but hope it at least clarifies my issue. In the example you see two categories:

In A1 I load in Category1 A1. In B1 it loads the answer of Category1 B1 (0). But I want not the answer, I want to load in the formula code: =SUM(D6:D9) where the answer should be: 10 instead of zero.

You probably should have had some explanations on what you are trying to achieve in your sample.

In A1 you see that Category1 A1 is loaded in. In B1 it loads the answer of Category1 B1 (0). But I want not the answer, I want to load in the formula code: =SUM(D6:D9) from the Category1 page. And that should make the answer 10 instead of zero.

So I want to load the function formula code from the Category1 page and find the answer on every page where I place this. I can see the text: "Test 1" and I can load this in with the code: =Category1!A1. But how can I load in the formula function so that it does the same thing as the Test 1 with an correct answer?