lookup sheet name

[callen12]

I know this is simple but cant get my head around it to work

I have a spreadsheet tab names Master, List , and 1-31.

List sheet has name range (Subtotal) listing sheet names and value in cell F30. 3 column is running sum. (H:J)

On each Tab (1-31) i want the running sum for the day from List sheet.

I know i can do this individually but cant figure out the indirect/vlookup formula so when i rebuild from my master after changes i dont have to modifiy each sheet/formula.

Convaluted but thats how my brain is working right now.lol.

Thanks for any help.

 

[jasonb75]

When pasted into cell

=VLOOKUP(REPLACE(CELL("filename",A1),1,FIND("]",CELL("filename",A1)),""),Subtotal,3,0)

Returns #N/A in all sheets except the master

Do you have an entry listed for "master" in column 1 of the subtotal table?

How are the cells with the sheetnames 1,2,3 etc formatted?