[Solved] Add value from other page indicated from a cell

[Puxo]

Im new to this and trying to work out a statistic sheet for my company.
I put in informatioen from other data sheet into different page (page2 and onward)
While "page1" is the main where all information is displayed later

I manage without a problem to make as exempel a sum from all columns in a page2 (namned Ark2 (using swedish)) with the
=SUMMA($Ark2.G2:$Ark2.G12)

But when I try to just extend the formula the "page" dont change with it only the "G" column change to as this exempel to G3->G13 instead

So I was thinking to just use the page reference from a cell instead.
As in the picture, I want to reference to the page "Ark4" and cell G2,
=Ark4.G2 (this works)
But instead I wanna use the info in the Cell B5, and read from that page
In my mind
=(Cell B5).G2 but I cant find any workaround for this.

Is it possible to read from a page indicated from a cell?

nuq9tjZ.png (5.11 KiB) Viewed 41 times

[FJCC]

It is possible to build cell references from text in other cells with the INDIRECT() function, but it is not very convenient. The attached file shows examples on Sheet1, rows 2 and 3. I calculate sums of values on Sheet2 and Sheet3, putting the sheet name in column A and building the formula in column B.
What you are struggling with is probably a result of spreading your data over multiple sheets. On Sheet4 of the file, I condensed the data from Sheets 2 and 3, using column F to label the data. In real data, column F would not say "Sheet2" but would have an informative label. If Sheet2 was separate because it held data from January, then column F of Sheet4 would contain January for those rows. There are formulas on Sheet1 that use the labels from Sheet4's column F to sum subsets of the data. I used SUMIF() and SUMPRODUCT(). I prefer SUMPRODUCT(), but eitherone works. This is a much cleaner way to handle the data. New values and labels can be added to the data set without needing to change the formula structure.

[Puxo]

Thanks alot! This helped so much.
I changed some data to the data sheet, but also used the INDIRECT() function to pull data from the data sheet to my main display sheet.

Thanks!