Need Help trying to automatically organice data from new sheets

[OrlandoMX]

I will try to explain fully my problem as i'm not english native, hope you can help me.

I have a workbook, in it I constantly create several sheets and use the same page format with different data in all of them, which I rename different(for example: 'A1 B1', 'A1 B2', 'A2 B1', etc.)
In the end i want to create a summary of a specific cell of each sheet that updates itself as i am creating new sheets
What i think of doing is using the =concatenate formula (so i get the text for example: ='A1 B1'!$V$10, and in the next 'A1 B2'!$V$10)
in the end i only get the text, but not the data i want it to appear, so i don't know how to make it so i get the value instead of the text. (i tried copying the text and pasting it with Formating (R) and it works, but i was hoping there's a way to automatically do it.

PD: sorry if it's in the wrong section, hope someone can move it if it's in one that it shouldn't be.