Tip : Use Wildcard to Sum Cells

Use Wildcard to Sum Cells : 

Here is quick tip:

If you have multiple sheets of different stores sales data and the challenge is to make summary report by summing up all the Delhi stores sales or the Mumbai store sales etc.. Then here is a tip:

Use wildcard "*" in sum formula.

=sum('de*'!G4)

It will sum all state that is started with "De" having sales value in G4 cell of each sheet.