Find and sum the exact match across multiple worksheets

Hello Friends,

I have to call data from multiple sheets (named on site address) and add them. I have exported them from tally. There is a summary sheet (GrpCmpny) in which all the ledgers are. Can u help me to solving it. I have attached file for reference.

Regards,
Sandeep Giri,
Ayoki Fabricon (P) Ltd.
Pune, India.