Sheets -> Google Sheets (not PC excel)

I have multiple data to import into a Master sheet from multiple sheets within the same spreadsheet. So I don't want to use (for example) =Sheet1!$A$23 or IMPORTRANGE (as it's the same sheet and again I have to hard code the sheet names)

As the data is a lot, and sheet names have spaces too, so I need a formula/function which picks the sheet name from the column cell and pick the data address i.e. X1 where data is available in the multiple sheets

NOTE: I can hard code the data cell (i.e. $A$23), as it would be the same in my case. But can't hard code the sheet names. It would be great if the address of the sheet name and data cell of that sheet can be picked from cells.

NOTE: Data to get from the multiple sheets are simple amounts, like expenses, as mentioned in the header.

Explanation: In multiple monthly expense sheets, some data cells are just values (like year, month, etc.) and some have functions like =SUM(B23:Z23) showing the total expense of that month which I want to bring/copy/show in the Master sheet.

Is there any solution available for this problem?

CodePudding user response：

Try in X3

=INDIRECT("'"&text(Y3,"MMM yyyy")&"'!"&$X$1)

see