I got my answer. I feel really stupid here. But my tabs actually had names
as opposed to "sheet" once I filled the names in on the formula it worked.
Thanks for your help.

"sanj" wrote:

I have 20 tabs in my excel file.I need to check sum of
numbers in cell A14 for all 20 tabs.Instead of going to
each tab and adding A14 cell for each tab , is there any
formula or trick to get total? thanks for the help

Sanj