EASILY Lookup Values from Another Worksheet in Excel!

[@rachelkulshrestha2704]

Hi Sir, I have Multiple Sheet(150) and I want to Pull Just Single data form a Cell for all Sheet, Could you help me with any Formula.

[@ErinQin-qk5us]

Hi Sir, can we have a collaboration?

[@kevincecchini]

Hi, it does not work. my formula: =(SUM(INDIRECT(A48&"!"&"k249"))) and this returns, #ref! I have tried with and without sum function.